formula problem

[krispar]

hi,
my question is :-
how can we fetch correct value by using vlookup formula when lookup value is more than 1 time in the first column of table array as well as in the column in which we are applying vlookup.
For example:-

Batch (given) Curr.(to be fetched from table)
3825
2125
3825


Table array(Given)
Batch Curr.
2125 GBP
3825 EUR
3825 SEK
3254 GBP

 

[sudipto3003]

hi,
will you please upload an example file? that will clear the members to understand your problem.

 

[Somendra Misra]

Hi Krispar,

Please find the attached file, with two methods.

1. INDEX()
2. VLOOKUP with helper cell.

Kindly advise if any issue.

Regards,

 

[krispar]

Thanx for your precious time and advice ...thank You

 

[kchiba]

How do you know which is the correct value?