| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a List From Worksheets in a WorkBook | Excel Worksheet Functions | |||
| CREATING MULTIPLE DROP DOWN LISTS IN SAME EXCELWORKBOOK | Excel Discussion (Misc queries) | |||
| How do I combine lists in multiple worksheets | Excel Worksheet Functions | |||
| lists w/ multiple worksheets q | Excel Discussion (Misc queries) | |||
| creating drop down lists where you can select multiple values | Excel Discussion (Misc queries) | |||
Hybrid Mode
