Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down lists
I have created two drop down lists that link to each other using the
validation settings and typing in the INDIRECT formula. However i cannot create a third list that links in, when i do make a third list it is just the same as the second one. Can anyone help? -- Kind Regards Jaspal |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down lists
To create a third list, you could create named ranges based on the
contents of the first two dropdowns, or the second dropdown. For example, if the selection in the first dropdown is a country, and the second dropdown is a state, you could have a named list of cities for each state. Then, use the INDIRECT function to reference the cell that contains the second dropdown. Jaspal wrote: I have created two drop down lists that link to each other using the validation settings and typing in the INDIRECT formula. However i cannot create a third list that links in, when i do make a third list it is just the same as the second one. Can anyone help? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I have hierarchial drop down lists in Excel | Excel Worksheet Functions | |||
drop down lists | New Users to Excel | |||
Drop Down Lists | Excel Worksheet Functions | |||
Data Validation - Drop down lists - if then? | Excel Discussion (Misc queries) | |||
Can different drop down lists be displayed depending on the value. | Excel Discussion (Misc queries) |