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

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

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

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))

"Ken" wrote:

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

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

Try this:

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

--
Biff
Microsoft Excel MVP


"Ken" wrote in message
...
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

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

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))


--
Biff
Microsoft Excel MVP


"T. Valko" wrote in message
...
Try this:

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

--
Biff
Microsoft Excel MVP


"Ken" wrote in message
...
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

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

Hello! Daddy Long Legs,

Thank you very much! It works well.

Ken