Hello everyone,

From "Contexture.com", I was able to learn how to create a one dependent drop down list.

However, I need to have 2 dependent list based on the first list.

1) My first list is of the department names
2) Each department has a list of capital expenditures, which I was able to name as the department name and was able to get my first dependent list.
3) But I need one more dependent list for the asset class.

As the names of the departments has already been used to create the first dependent list, I am not sure what to do to create the 2nd dependent list.

Shahid

If the first dropdown is in A2 and the second dropdown is in B2, the
data validation for cell C2 could be: =INDIRECT(A2 & B2)

For example, if A2 contains Finance, and B2 contains Computers, C2 would
show a dropdown based on a range named FinanceComputers.

SSJ wrote:
Hello everyone,

From "Contexture.com", I was able to learn how to create a one
dependent drop down list.

However, I need to have 2 dependent list based on the first list.

1) My first list is of the department names
2) Each department has a list of capital expenditures, which I was able
to name as the department name and was able to get my first dependent list.
3) But I need one more dependent list for the asset class.

As the names of the departments has already been used to create the
first dependent list, I am not sure what to do to create the 2nd
dependent list.

Shahid


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html