Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I assign a set of values to a selection from a drop list?
Hi. I am trying to assign a set of values, in separate fields ,to a each
selection from a drop-down list in Excel (using data validation). What I am trying to do is very smilar to, say, to selecting a SKU from a list and having the product description, unit price etc. fill into their corresponding fields automatically. For example, I pick SKU "11111" from a drop-down list to fill the SKU field, then, automatically, "5-inch widget" comes up in the product description field and "$5.00" shows up in the unit price field. Please help. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I assign a set of values to a selection from a drop list?
Mike
Along with the drop-down list you need a VLOOKUP table to return the values such as description and price. See Debra Dalgleish's site for more on VLOOKUP and a downloadable sample file. http://www.contextures.on.ca/xlFunctions02.html Gord Dibben MS Excel MVP On Tue, 7 Mar 2006 09:01:28 -0800, Mike Bach <Mike wrote: Hi. I am trying to assign a set of values, in separate fields ,to a each selection from a drop-down list in Excel (using data validation). What I am trying to do is very smilar to, say, to selecting a SKU from a list and having the product description, unit price etc. fill into their corresponding fields automatically. For example, I pick SKU "11111" from a drop-down list to fill the SKU field, then, automatically, "5-inch widget" comes up in the product description field and "$5.00" shows up in the unit price field. Please help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Limit drop down list and linking to other info | Excel Worksheet Functions | |||
re-ordering the list on a filter drop down | Excel Discussion (Misc queries) | |||
Formula to total items from a drop list with values in several col | Excel Discussion (Misc queries) | |||
changing value of a cell by selecting an item from a drop down list | Excel Worksheet Functions | |||
Extracting Values on one list and not another | Excel Discussion (Misc queries) |