|
|
#2
04-19-2017, 11:04 AM
|
||||
|
||||
Assuming you are looking for first match that is >= search value, try, in F1:
=INDEX($J$2:$J$6,MATCH(TRUE,INDEX(INDEX($J$2:$P$6, 0,MATCH(E1,$J$1:$P$1,0))>=D1,0),0)) copied down 
|
| Tags |
| vlookup |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| It seems as if wdFindStop isn't working properly | tfurnivall | Word VBA | 3 | 05-06-2016 09:58 AM |
| VLOOKUP not working properly with data digiting, only copy&paste | Mike84bs | Excel | 3 | 05-06-2015 10:01 AM |
 Indentation Not Working Properly
|
LaC0saNostra | Word | 2 | 02-01-2015 11:35 AM |
|
Freeze Pane isn't working properly
|
ep2002 | Excel | 1 | 07-27-2014 06:53 PM |
|
[Publisher] Fonts not working properly
|
pajkul | Publisher | 1 | 01-23-2011 07:51 PM |
Windows 7 64bit 
Office 2007
Threaded Mode