Assuming that you have 100 different items (number in A and description
in B) A1:B100

use a vlookup in G1

=VLOOKUP(C1,$A$1:$B$100,2)

and just drag and fill to the same area size as C1:F??


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=552302