Previous Topic Next Topic

Vlookup with condidion

Closed
Karthikeyan1207 Posts 16 Registration date Wednesday November 26, 2014 Status Member Last seen August 3, 2020 - Updated on Jul 29, 2020 at 05:33 AM
Karthikeyan1207 Posts 16 Registration date Wednesday November 26, 2014 Status Member Last seen August 3, 2020 - Aug 3, 2020 at 03:23 AM
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

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

Similar discussions

Comparing columns and returning value
ll -
kittu -

35 responses
Match partial text string in one sheet to another text string in another sheet
Santos -
Santos -

2 responses
Lookup partial text contained in cell range
Tom -
Tom -

4 responses
Using Vlookup to return insted of 00/01/1900
Tom9o -
tom9o -

2 responses
add/subtract & vlookup formula
sudhir -
sudhir -

2 responses