Vlookup with condidion

[Closed]
Report
Posts
18
Registration date
Wednesday November 26, 2014
Status
Member
Last seen
August 3, 2020
-
Posts
18
Registration date
Wednesday November 26, 2014
Status
Member
Last seen
August 3, 2020
-
HI Team
Pls help to make a vlookup with condition as explained below.

Data reference as below

Column A Column B Colum C
X1 15-Aug Y1
X2 20-Aug Z1
X3 25-Aug B1
X1 20-Aug Z1
X1 22-Aug K1


Now i want to do VLookup from other worksheet for colum A value . In above table , for X1 - there are 3 dates in column B - 15th Aug, 20th Aug, 22-Aug.

While vlookup i want to return the value from Column C with latest date in Column B for X1 ... i.e , For X1- the latest date is 22-Aug and the corresponding Column C value is K1 .. I need this "K1" data to be returned in Vlookup.



Pls help if any option .

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
I dont think VLOOKUP will work. Even getting the max date would require array formula. I feel your best bet is to create a custom function
2
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Posts
18
Registration date
Wednesday November 26, 2014
Status
Member
Last seen
August 3, 2020
1
Hi , Thanks for your feedback , let me try some formulas. Pls also suggest if you could get some formula . Thanks again for checking .

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!