formula help - value in cell looking up row and column using great than less than
hello,
i am looking for help on a formula returning a value of a cell in a table.
the challenge is there is no absolute number - it needs to read between two numbers.
the scenario is - i have a kitchen door size of 715x450 and i want it to look up the height in the correct column between two values - then look up the correct width between two values and return the price.
this is complicated to explain. so i have attached an example of a table.
much appreciated.
thank you
stefano
|