Microsoft Office Forums - View Single Post - Vlookup fails to select latest date/amt

Thread: Vlookup fails to select latest date/amt

View Single Post

Old

01-27-2019, 03:07 AM

alpha

alpha is offline

alpha uses Windows 10

Windows 10 alpha uses Office 2010 64bit

alpha uses Office 2010 64bit

Office 2010 64bit

Novice

Join Date: Jun 2018

Posts: 18

alpha is on a distinguished road

Default

Quote:

Originally Posted by rbul1

View Post

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

Reply With Quote