Vlookup fails to select latest date/amt

alpha · #1 01-27-2019, 03:07 AM

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)

rbul1 · #2 02-16-2019, 08:19 AM

Thank You, you were correct!

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