anti vlookup

[isameer]

Hi,

I want to know if we can use vlookup for lefthand side columns?

in vlookup function excel looks up only right handside columns how to use if we want it to look lefthand side columns?

[Bob Phillips]

Use INDEX and MATCH in tandem

=INDEX(A:A,MATCH("x",C:C,0))