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