Creating lists from multiple worksheets within one workbook...

[Corey]

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?

 

[Gord Dibben]

VLOOKUP formulas will pull the data to appropriate cells.

See Debra Dalgleish's site for more on VLOOKUP and Data
Validation lists for entering the choices.

http://www.contextures.on.ca/xlFunctions02.html

http://www.contextures.on.ca/xlDataVal01.html

Note the section on using DV lists from another worksheet by naming the list.


Gord Dibben MS Excel MVP