Link to home
Start Free TrialLog in
Avatar of Zack
ZackFlag for Australia

asked on

Excel Vlookup Query2

Heyas,

I want to be able to select the name Truck (Truck_GE2) that has the most recent date assigned to it. How would I do this in Vlookup statement.  See the attachment which has a table of values.

Thank you.
Book1.xls
Avatar of John-Charles-Herzberg
John-Charles-Herzberg
Flag of United States of America image

Avatar of Zack

ASKER

Nah it wouldn't work see attached again made an alteration. Need to also filter by the first column, the value I want is Truck_GE2.  So in summary it needs to work out values in column A have Truck contained in it and then to find the which one of those values has the most recent date.

Thank you.
Book1.xls
Avatar of Patrick Matthews
Try this array formula:

{=MAX(IF(LEFT(A1:A4,5)="Truck",B1:B4,""))}

To enter an array formula, do not enter the curly braces, and hit Ctrl+Shift+Enter instead of Enter to finish it off.  Excel will then display those braces to indicate that it's an array formula.
If you want to show the most recent date of each vehicle listed in column A, use the formula found in column C

Flyster
Book1.xls
Avatar of Zack

ASKER

Thats getting close but I want to list the Vehicle that has the "Most Recent" date assigned to it.

See attachment for the answer should be.

Thank you.



Book2.xls
Avatar of Zack

ASKER

My apologies for the delay my net connection has been down.
ASKER CERTIFIED SOLUTION
Avatar of Flyster
Flyster
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Zack

ASKER

Thank you.