ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Drop down lists (https://www.excelbanter.com/excel-discussion-misc-queries/99076-drop-down-lists.html)

Jaspal

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

Debra Dalgleish

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 07:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com