Home |
Search |
Today's Posts |
#1
|
|||
|
|||
drop down list
Hello,
I am hoping someone out there can help me with my current problem. I would like to use a drop down list and when a specific item is chosen the next couple of cells below it are populated with data depending on which item was selected. Is this possible or relatively easy to do if so how do I go about doing it. Thanks for your time. Any input is appreciated. c |
#2
|
|||
|
|||
You can use Data Validation to create dropdown lists. There are
instructions in Excel's help, and he http://www.contextures.com/xlDataVal01.html To return the related information for the selected item, you can use a VLookup formula. There are instructions and examples he http://www.contextures.com/xlFunctions02.html There's a sample file that uses Data Validation and VLookup formulas he http://www.contextures.com/excelfiles.html#Function Under Data Validation, look for 'Order Form' c wrote: Hello, I am hoping someone out there can help me with my current problem. I would like to use a drop down list and when a specific item is chosen the next couple of cells below it are populated with data depending on which item was selected. Is this possible or relatively easy to do if so how do I go about doing it. Thanks for your time. Any input is appreciated. c -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
c
You could use the VLOOKUP Function with a table. See Debra Dalgleish's site for info. http://www.contextures.on.ca/xlFunctions02.html While you're there check out using Data Validation drop-downs for entering values to lookup. http://www.contextures.on.ca/xlDataVal01.html Gord Dibben Excel MVP On Wed, 23 Mar 2005 09:27:04 -0800, "c" wrote: Hello, I am hoping someone out there can help me with my current problem. I would like to use a drop down list and when a specific item is chosen the next couple of cells below it are populated with data depending on which item was selected. Is this possible or relatively easy to do if so how do I go about doing it. Thanks for your time. Any input is appreciated. c |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
select drop down list 1 value will change the value in dr... | Excel Worksheet Functions | |||
Pull unique names for drop down list | Excel Discussion (Misc queries) | |||
automatic color change in cells using a drop down list | Excel Worksheet Functions | |||
How to change fonts in drop down list | Excel Discussion (Misc queries) | |||
Drop List Referencing | Excel Worksheet Functions |