Inserting lists from a drop down menu????

J

Jim Johnson

I am trying to build a spreadsheet where I can insert the parts list fo
various assemblies based a single part number that represents tha
assembly. I would like to do this using a drop down pick list i
possible. I do not know VB(probably should though) so can anyone offe
some help for this
 
P

pinmaster

How about this:
In an out of the way of your workbook, create a table with all you
part number in one row and under each part number fill down you
individual list.
Next select a cell to put your part numbers list in, say A1, got
Data/Validation select "list" in the Allow menu and in the formula bo
below type = and the location of your part numbers range. Next put thi
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 an
then use:
=HLOOKUP($A$1,table1,ROW(2:2),0)

HTH
J
 
Top