DEPENDENT DROP DOWN LIST

  • Thread starter Thread starter SSJ
  • Start date Start date
S

SSJ

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