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!