#1
|
|||
|
|||
Microsoft Excel, Drop Down List
Hi,
I need to be able to select an item from a drop down list and then for my selection to then populate several cells with pre determined information from another sheet. For Example... If I Select the 'Vanilla' option of ice cream from a drop down list on Sheet 2. I need it to look at Sheet 1, Row 6 and copy Cells A6, B6, C6 & D6. Then populate Sheet 2, Row 2 with the copied info. I'm a novice to excel so if this is possible can you please explain a simple as possible. Thanks loads for any help you can provide. If you need more info from me, then just let me know. Cheers Phibir |
#2
|
|||
|
|||
Try VLookup or Match/Index functions assuming each selection of Vanilla (6), Chocolate (7), Strawberry (8), etc. has the same number of elements.
In a reference table, have flavors and reference values in adjacent cells (6, 7, 8, etc.). In a lookup table, have those same reference values with elements to the right. =Vlookup("Vanilla",<reference table>,<column 2>,<true/false>) the result would be 6 Then you could us = Index(<lookup table>,<row - from reference table>, <column 1...4 - for elements>) I hope that was simple and complete enough to point you in the right direction. If you use formulas in Excel, you can start with =VLookup(... and get the data needed for the formulas. EXTRAS: You can combine both tables into one on a hidden sheet and use that to enable your pick list of flavors and the results that get displayed. You can also define name ranges for your tables to make for simpler formulas If the number of elements/ingredients vary with the selection, that's possible too, but you may need to get more creative with how you manage reference values |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to import list from Excel into drop-down list into word | ahw | Word VBA | 43 | 02-28-2020 08:11 PM |
Populate Word Drop-down list with Excel column then auto fill form fields with Excel data | Faldinio | Word VBA | 7 | 10-19-2014 06:03 AM |
(Excel 2007) Need help with colour change when condition met in drop down list | oalrashdan | Excel Programming | 1 | 12-13-2013 02:21 AM |
Microsoft Excel 2010 - To Do List | teza2k06 | Excel | 2 | 03-05-2013 11:13 AM |
drop down list from external data source Excel 2007? | Intruder | Excel | 1 | 08-03-2012 05:41 AM |