|
|
#2
10-16-2016, 06:35 AM
|
|||
|
|||
=IF(F3>MAX(A2:A4),"",INDEX(B2:d4,MIN(IF(A2:A4>F3,R OW(A2:A4)-1)),MATCH(F2,B1:d1,0)))
It is an array formula so when entering remember to hold down Ctrl and Shift before pressing Enter. If you do it correctly Excel will automatically put braces {} around the formula. 
|
| Tags |
| array, lookup, match/index |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Need to default the Cost Column based on another column's value
|
ProjectCalcs | Project | 1 | 10-03-2016 07:02 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 |
| Rounding to nearest 0.25 | Guloluseus | Excel | 5 | 10-27-2015 11:28 PM |
| Mouseover cell to indicate mouse pointer location based on Specific Row/Column values | bolandk | Excel | 1 | 05-15-2014 08:22 AM |
|
Need help on duplicates in column; deciding which to keep based on other column
|
nwcf | Excel | 3 | 01-31-2014 09:43 AM |
Windows 10 
Office 2016
Threaded Mode