Creating lists from multiple worksheets within one workbook...
 

I've got a list of information on a separate sheet within my workbook,
and I'm wanting to create a pull-down list to choose from the options
provided. However, I also want that result to automatically generate
or fill in other fields associated.

I.E.

I have a database of Products, and next to each, I have the weight,
price, shipping costs, etc. on one worksheet.
On a more user friendly sheet, I have a pull down that allows the user
to select one of the products. When they select the product, I want
the other info (weight, price, shipping costs, etc.) to automatically
fill in based on what product they choose. Nested IF statements will
only take me so far as I have far more products than the maximum
allowed number of nested ifs.

Anyone have any suggestions?

Creating lists from multiple worksheets within one workbook...
 

try VLOOKUP:

Assume in "Database" data is in columns A to H: A is product Id

=VLOOKUP(A2,Database!A2:H100,2,0) will extract column B (weight) from your
database for Product in A2 - your drop down list
=VLOOKUP(A2,Database!A2:H100,3,0) will extract column C (price) from your
database for Product in A2

etc

HTH


"Corey" wrote:

I've got a list of information on a separate sheet within my workbook,
and I'm wanting to create a pull-down list to choose from the options
provided. However, I also want that result to automatically generate
or fill in other fields associated.

I.E.

I have a database of Products, and next to each, I have the weight,
price, shipping costs, etc. on one worksheet.
On a more user friendly sheet, I have a pull down that allows the user
to select one of the products. When they select the product, I want
the other info (weight, price, shipping costs, etc.) to automatically
fill in based on what product they choose. Nested IF statements will
only take me so far as I have far more products than the maximum
allowed number of nested ifs.

Anyone have any suggestions?