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)

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 07:33 AM.