Vlookup fails to select latest date/amt

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Vlookup fails to select latest date/amt

01-27-2019, 03:07 AM

alpha

Windows 10 Vlookup fails to select latest date/amt

Office 2010 64bit

Novice

Join Date: Jun 2018

Posts: 18

Quote:

Originally Posted by rbul1

=Vlookup(Max($D$4:$D20),$D$4:$G20,2,T) formula in D4

Try this, but with the formula not in D4 but in a cell outside the data table:

Code:

=VLOOKUP(MAX($D$4:$D20);$D$4:$G20;2;0)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
return the status description relating to the latest date in	garymon9AX	Excel	2	08-21-2018 10:02 AM
What is the Latest Version of MS Office in 2018?	adbast	Word	3	05-15-2018 12:12 PM
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
Lookup & Import Earliest/Latest Date for Activity?	ekeithjohnson	Excel	1	08-25-2014 09:24 AM
the latest message in my inbox gets deleted	Jmkary	Outlook	1	01-27-2011 12:36 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:18 AM.