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