Vlookup dates that are higher than a given one

		Microsoft Office Forums > Microsoft Excel > Excel
Vlookup dates that are higher than a given one

02-15-2018, 07:52 AM

NBVC

Windows 10 Vlookup dates that are higher than a given one

Office 2013

The Formula Guy

Join Date: Mar 2012

Location: Mississauga, CANADA

Posts: 215

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))

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How can I return Vlookup only if Specific Criteria is met in 1 column of the Vlookup Array	EcommDOC	Excel	7	01-22-2018 11:00 AM
Autofill dates - how can I get the same date and consecutive dates?	Exhale	Excel	3	04-05-2016 03:11 AM
Replace a number with one higher	urbandekay	Word	7	03-27-2016 01:41 AM
Tasks with higher priorities	jamiespear	Project	1	02-10-2015 03:29 PM
Top of 2nd page higher than 1st	Anne at ppf	Word	7	03-23-2013 07:55 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:58 PM.