Avatar of Zack
Zack
Flag 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
Microsoft Excel

Avatar of undefined
Last Comment
Zack

8/22/2022 - Mon
John-Charles-Herzberg

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
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.
Your help has saved me hundreds of hours of internet surfing.
fblack61
Flyster

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
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
Zack

ASKER
My apologies for the delay my net connection has been down.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER CERTIFIED SOLUTION
Flyster

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Zack

ASKER
Thank you.