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