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

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

Have a look at Chip Pearson's methods of left lookup.

http://www.cpearson.com/excel/lookups.htm#LeftLookup


Gord Dibben Excel MVP

On Sat, 8 Oct 2005 14:11:55 -0500, Brisbane Rob
wrote:


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

Thanks, guys - I can now do it two ways!
Much appreciated


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