![]() |
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 |
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 |
All times are GMT +1. The time now is 01:56 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com