Vlookup Range

[Abdul Matheen]

Hi Guys,

I have question in vlookup formula. VLOOKUP always picks the first value, do anybody know how to pick the second lookup value using the same range.

Example:
In the below table if i do the vlookup formula for ABC as my lookup value for the range A1:B4 for the column 2 it will gives the result as 5 at the first row, i need the value in row 3 that is 6, using the same range that is (A1:B4).

A B
1 ABC 5
2 CDE 4
3 ABC 6
4 FFE 8



Thanks.

 

[NARAYANK991]

Hi Abdul ,

You can read about the technique here :

http://chandoo.org/wp/2011/11/18/formula-forensics-003

Narayan

 

[Abdul Matheen]

Hi Abdul ,

You can read about the technique here :

http://chandoo.org/wp/2011/11/18/formula-forensics-003

Narayan

Thank you very much Narayan... I got the answer.

Abdul Matheen