formula help - value in cell looking up row and column using great than less than

stefano · #1 10-20-2017, 06:35 AM

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

OTPM · #2 10-20-2017, 07:28 AM

Hi
This will need testing but this is as close as I can get. I am sure there are more elegant solutions.
Hope this helps.
Tony

Debaser · #3 10-20-2017, 09:34 AM

If you list the start values for each range, you can use INDEX and MATCH as in the attached.

stefano · #4 10-20-2017, 02:20 PM

hi Guys - you are legends - many thanks, you have saved me many many hours of heartache.

thank you again and have a nice day

Stefano

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Is it possible to put a formula in a table column header to define the name of the column?	JacquesW	Excel	3	05-08-2017 08:00 AM
Entering a column value in a cell, to be used as part of a reference in a formula in another cell	paulkaye	Excel	4	02-26-2017 04:18 AM
If value of cell A Matches a value in a Range of cells (column) then add value of cell A to cell C	rick10r	Excel	1	07-05-2016 12:07 PM
What formula can I use to find the lowest cell in a column that has a value in it?	EddyWD	Excel	3	04-20-2016 09:29 PM
Need help with dragging a formula and changing a reference column as I drag the formula.	LupeB	Excel	1	10-22-2015 03:02 PM