vlookup a value in column B but return value in Column A

[Guest]

Hi!

I am wondering if there is any way we can vlookup a certain value in column
B but return value in Column A.

Thank you very much!

Ken

 

[Guest]

Hello Ken,

You can't do that with VLOOKUP but you can use an INDEX/MATCH type formula,
e.g. to lookup C1 in column B and return the corresponding value from column A


=INDEX(A:A,MATCH(C1,B:B,0))

 

[T. Valko]

Try this:

=INDEX(B1:B10,MATCH(lookup_value,A1:A10,0))

 

[T. Valko]

Ooops!

I have the ranges backward!

=INDEX(B1:B10,MATCH(lookup_value,A1:A10,0))

Should be:

=INDEX(A1:A10,MATCH(lookup_value,B1:B10,0))

 

[Guest]

Hello! Daddy Long Legs,

Thank you very much! It works well.

Ken