Drop down lists

J

Jaspal

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?
 
D

Debra Dalgleish

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.
 
Top