how to indirect / index a value in a table

[toeragh]

I have a table setup - Height & Width with the values of 100, 150, 200, 250 etc upto 1000
in the table there is a cost associate with the different values.

I have attached the sheet.

If I enter height 100 and width 100 - the result should be 22.72

I'm struggling to build a formula to do it - I have tried match, vlookup to no avail

Peter.

[Colin Legg]

Hi Peter,

This is a "double" lookup formula which can be done quite nicely using INDEX() and MATCH().

In cell C27 type in 150. This will be the Height.
In cell C28 type in 400. This will be the Width.

In cell C29 type in this formula:

=INDEX(A2:Q22,MATCH(C27,A2:A22,0),MATCH(C28,A2:Q2,0))
The precise sizes of the ranges is your choice but you need to make sure that the lookup row/column start and finish in line with the index reference.

[toeragh]

Hi Colin, works a treat, thanks,