=vlookup(match(12,a1:a10,1),a1:b10,2,false)


--
dcronje
------------------------------------------------------------------------
dcronje's Profile: http://www.excelforum.com/member.php...fo&userid=5281
View this thread: http://www.excelforum.com/showthread...hreadid=320595