Is it possible to create a vlookup that looks firsly down the second
column in a table to find the cell value but then brings back the value
from the 1st column?

Thanks, Tim


--
timmyc
------------------------------------------------------------------------
timmyc's Profile: http://www.excelforum.com/member.php...o&userid=31198
View this thread: http://www.excelforum.com/showthread...hreadid=517278

=INDEX($A$1:$A$100,MATCH(value,$B$1:$B$100,0))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"timmyc" wrote in
message ...

Is it possible to create a vlookup that looks firsly down the second
column in a table to find the cell value but then brings back the value
from the 1st column?

Thanks, Tim


--
timmyc
------------------------------------------------------------------------
timmyc's Profile:
http://www.excelforum.com/member.php...o&userid=31198
View this thread: http://www.excelforum.com/showthread...hreadid=517278

Hi,

Bob, you beat me to this one :-)

Tim,
If you want some explanation of Bob's formula, check out:
http://www.ozgrid.com/Excel/left-lookup.htm
or
http://www.cpearson.com/excel/lookups.htm
or even Google "left lookup", excel

hth,
Rob Brockett
NZ
Always learning & the best way to learn is to experience..

--
broro18
-----------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php...fo&userid=3006
View this thread: http://www.excelforum.com/showthread.php?threadid=51727

Hi,

Bob, you beat me to this one :-)

Tim,
If you want some explanation of Bob's formula, check out:
http://www.ozgrid.com/Excel/left-lookup.htm
or
http://www.cpearson.com/excel/lookups.htm
or even Google "left lookup", excel

hth,
Rob Brockett
NZ
Always learning & the best way to learn is to experience...


--
broro183
------------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068
View this thread: http://www.excelforum.com/showthread...hreadid=517278

If you want a strictly vlookup solution, propagate a formula copy of column A
into column C, (eg, in cell C1 put "=A1", and copy all the way down.) Then
you can use a normal vlookup syntax on column B, and your offset will 2.
This has been useful for me when there is an existing vlookup and you cannot
move columns around.

Regards,
Antonio Elinon


"timmyc" wrote:


Is it possible to create a vlookup that looks firsly down the second
column in a table to find the cell value but then brings back the value
from the 1st column?

Thanks, Tim


--
timmyc
------------------------------------------------------------------------
timmyc's Profile: http://www.excelforum.com/member.php...o&userid=31198
View this thread: http://www.excelforum.com/showthread...hreadid=517278