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