View Single Post
 
Old 04-19-2017, 11:04 AM
NBVC's Avatar
NBVC NBVC is offline Windows 7 64bit Office 2007
The Formula Guy
 
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default

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
Reply With Quote