Conditional Drop Down Boxes

[Guest]

I am trying to set up a worksheet for a pipeline report. I need to set up
Conditional Drop Down Boxes that are contingent upon the drop down Choice in
a previous Drop Down Box. The problem is that I have to set up more than one
Dependent Drop Down Box for the same master Data Validation box. I tried the
Contextures website, bu I could not see how to do it with either Dependent
Lists, Dynamic Lists, or Sorted Lists.

Has anyone found a practical solution for this?

 

[Debra Dalgleish]

I'm not sure what you need, or what you've tried, but maybe created
named ranges with variations of the main items' names. For example, if
the main items are Fruit and Veg, have ranges names FruitList1,
FruitList2, VegList1 and VegList2.

In the first dependent cell, Allow List, and use the data validation
formula:
=INDIRECT(A2&"List1")
In the second, use:
=INDIRECT(A2&"List2")