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!
|