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