Vllokup

[rk0909]

I am trying to use a Vlookup formula but the reference value is not in the
first colum of the range but in the third. Is there a way to get around it.
Thanks in advance.
RK

 

[Toppers]

Not with VLOOKUP but perhaps INDEX/MATCH. Can you give an example of your
data?

 

[rk0909]

actually it did work using index/match combination. Thanks.