=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