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