Thread: [Solved] Vlookup dates that are higher than a given one
View Single Post
 
Old 02-15-2018, 07:52 AM
NBVC's Avatar
NBVC NBVC is offline Windows 10 Office 2013
The Formula Guy
  
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default
This will return the first match for B3 where shipdate is later than the C3 date:

=INDEX(L6:L10,MATCH(1,INDEX((J6:J10=B3)*(L6:L10>C3 ),0),0))
Reply With Quote