|
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
10-20-2017, 06:35 AM
|
|||
|
|||
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 
|
| Thread Tools | |
| Display Modes | |
|
|
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 |
Windows 10 
Office 2016
Threaded Mode