How to get result value of 2nd instance instead of 1st when using Vlookup or Index/match??

[superexcelks]

Hello Everyone,

kindly please help me with the correct formulae I could use to get results of 2nd record instead of 1st record when using Vlookup or Index & Match formula.

My data looks like as mentioned below.

Employee Sales
ABC 100
XYZ 200
ABC 300

Now when I do vlookup to search sales value from column B1 for employee ABC it always returns 100 only whereas If I am doing search on 3rd Row it should return 300.

 

[AlanSidman]

Look at this workbook and the VBA included. Make sure you use the last option and indicate 2 for second item.

 

[bosco_yip]

Regards
Bosco

 

[pecoflyer]

Are you looking for the 2nd value or the last one ?

 

[deciog]

superexcelks

Checking, I noticed that you need to show the 2nd value, then you have another solution

I hope I have helped

Decio

 

[xlstime]

Alternately, you can use helping column and apply running countif and then put formal vlookup with 2