Previous Topic Next Topic

Vlookup with condidion

Closed
Karthikeyan1207 Posts 16 Registration date Wednesday 26 November 2014 Status Member Last seen 3 August 2020 - 29 Jul 2020 à 05:32
Karthikeyan1207 Posts 16 Registration date Wednesday 26 November 2014 Status Member Last seen 3 August 2020 - 3 Aug 2020 à 03:23
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 response

Réponse 1 / 1
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
2 Aug 2020 à 00:32
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
Karthikeyan1207 Posts 16 Registration date Wednesday 26 November 2014 Status Member Last seen 3 August 2020 1
3 Aug 2020 à 03:23
Hi , Thanks for your feedback , let me try some formulas. Pls also suggest if you could get some formula . Thanks again for checking .