vlookup returns column to the left

B

Brisbane Rob

I thought this would be easy but still can't get it. How do you get a
vlookup to return a value from a column to the left of the array?

Thanks
 
B

Biff

Hi!
How do you get a vlookup to return a value
from a column to the left of the array?
Click to expand...

You don't!

You could use some variation of Index:

Column A contains the value you want returned.
Column D contains the lookup value

=INDEX(A:A,MATCH(Lookup_value,D:D,0))

Biff

"Brisbane Rob" <[email protected]>
wrote in message
 
Top