How about this:
In an out of the way of your workbook, create a table with all your
part number in one row and under each part number fill down your
individual list.
Next select a cell to put your part numbers list in, say A1, goto
Data/Validation select "list" in the Allow menu and in the formula box
below type = and the location of your part numbers range. Next put this
formula in another cell and copy down:
=HLOOKUP($A$1,your_table,ROW(2:2),0)
you could also give your table a name for ease of use...say table1 and
then use:
=HLOOKUP($A$1,table1,ROW(2:2),0)

HTH
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=496687