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.

--
Regards,
Tom Ogilvy


"Shelly" <(E-Mail Removed)> wrote in message
news:0C9540D1-D11E-424A-A659-(E-Mail Removed)...
> 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!