Hi,

You need to use a VLOOKUP table - check out the help section to see how
to do this - it should be straight forward.

Ed


--
EdMac
------------------------------------------------------------------------
EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736
View this thread: http://www.excelforum.com/showthread...hreadid=529935