Hi!

How do you get a vlookup to return a value
from a column to the left of the array?

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"
wrote in message
news:Brisbane.Rob.1wlnie_1128801907.2445@excelforu m-nospam.com...

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


--
Brisbane Rob
------------------------------------------------------------------------
Brisbane Rob's Profile:
http://www.excelforum.com/member.php...o&userid=25096
View this thread: http://www.excelforum.com/showthread...hreadid=474502