Thread
:
Vlookup Not working Properly
View Single Post
04-19-2017, 11:04 AM
NBVC
Windows 7 64bit
Office 2007
The Formula Guy
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
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
NBVC
View Public Profile
Find all posts by NBVC