Lookup Result Based on Tabulated Criteria
Posted on 2014-03-24
I am trying to to create a look up formula that takes the number of beds for a hotel and then looks up the relevant hotel licence cost as indicated in the attached spreadsheet.
For the banding, assume that as soon as the banding threshold is reach e.g. 100 then that next banding shall apply.
Can anyone help?