Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop Down lists?
I am trying to create a drop down list in a cell when the item is selected it
will populate values for that item in different cells. i.e In a drop down menu you can select different types of shirts. When you select a particular shirt from that drop down menu it will populate a price in a different cell and a color in another cell. These values will be constant for each item. Thanks in advance... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop Down lists?
YOu can use data validation to create the dropdown list, and VLookup
formulas to show the related information in other cells. There are instructions here for an order form, that uses those techniques: http://www.contextures.com/xlOrderForm01.html Juhnny wrote: I am trying to create a drop down list in a cell when the item is selected it will populate values for that item in different cells. i.e In a drop down menu you can select different types of shirts. When you select a particular shirt from that drop down menu it will populate a price in a different cell and a color in another cell. These values will be constant for each item. Thanks in advance... -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
drop down lists | Excel Worksheet Functions | |||
Drop down lists | New Users to Excel | |||
Multiple lists with repeated values for dependet drop down lists | Excel Worksheet Functions | |||
drop down lists | Excel Worksheet Functions | |||
Help with IF and drop down lists on a look up | Excel Worksheet Functions |