Different Dependent Lists, based on value of first list

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have two columns setup, both with data validation. The 2nd column is
dependent upon the first , using the INDIRECT function in data validation.

Question - if a particular value is chosen in the first column, can the
dependnt list in the 2nd column be a different list?

Example - If the first column is selected as GOOD, the 2nd column is going
to pick from the named list of GOOD_CHOICES. If the first column is selected
as BAD, then the 2nd column whould pict from the list named BAD_CHOISES.

Thanks!
 
Insert=>Name=>Define

Name: List2
Refersto: =Indirect(Sheet1!$A$1 & "_CHOICES")

Then in the data validation, after you pick list, in the textbox put
=List2

Works for me.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Validation List (conditional) 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Check if information exist in one column and if it does, type appropriate text 1
Hide column based on data validation 0
Matching 2 lists 2
Data Validation based on Cell Value 4
Data Validation - Dependent List 3
Find a value in a sheet and replace it with another value if it matches 8

Back
Top