Hi there,

I have a 3 sheet model: inputs, outputs and data

In 'data' i have the following table with 4 columns (1 rating, and 3 options for pricing)

Rating Building 1 Building 2 Building 3
0.45 £100 £200 £300
0.5 £120 £210 £310
0.55 £130 £240 £315
0.6 £140 £250 £318

In Inputs tab, is a calculated rating figure (i.e. 0.47) and a drop down menu that a user can select either buiding 1, building 2 or building 3.

In outputs, i want to take the calculated figure and building selction to return the correct money value from the table. SO for example, if the calculated value was 0.47 (created by diving one number by another) and the user selected 'building 2' then the formula would return £200. (in this case the value would be taken from the 0.45 rating)

Can anyone help please?

i have it working for one column using a VLOOKUP but the issue lies in that it only works with 1 column

I would also need the formula to work so if it was 0.4 for example, it would return the 0.45 value as there is no lower and similarly if it was 0.7 then it would return the 0.6 value as there is nothing higher.

Many Thanks
Dan