Have a look at vlookup:
http://contextures.com/xlFunctions02.html
You may work solve the problem yourself after reading it, and it's not
wasted time.
--
John James
------------------------------------------------------------------------
John James's Profile:
http://www.excelforum.com/member.php...o&userid=32690
View this thread:
http://www.excelforum.com/showthread...hreadid=532147