Different Dependent Lists, based on value of first list
 

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!

Different Dependent Lists, based on value of first list
 

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.

--
Regards,
Tom Ogilvy


"Shelly" wrote in message
...
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!