i'm checking this vlookup out... it doens't look like it's what i need
becuase i'm not going to have the "part numbers" and the "part codes
all in the same row. the part codes won't be on this worksheet.

i've attached a sample of what i need to have happen

+-------------------------------------------------------------------
|Filename: ProMan1.zip
|Download: http://www.excelforum.com/attachment.php?postid=4222
+-------------------------------------------------------------------

--
beechum
-----------------------------------------------------------------------
beechum1's Profile: http://www.excelforum.com/member.php...fo&userid=3048
View this thread: http://www.excelforum.com/showthread.php?threadid=50142