Validation Lists and IF statements

[Guest]

Does anyone know if its possible to combine If statements
and a validation lists.

i.e
if Cell A1 = Yes then in cell B1 You would have List one
and if Cell A1 = No the Cell B1 displays List two you
have to choose from?

And so on if I wanted to included a 3rd list also

Thanks for your help in advance

 

[Aladin Akyurek]

If A1 would house a name referring to a list, you can have in B1, the data
validated cell,...

=CHOOSE(MATCH(A1,{"ListA","ListB","ListC"},ListA,ListB,ListC)

or

=INDIRECT(A1)

if the lists of interest are NOT defined by means of a dynamic formula with
OFFSET() or INDEX().

 

[Aladin Akyurek]

Forget the CHOOSE bit for an expression like {...} is not allowed in data
validation.
The INDIRECT() suggestion should work as long as the list names are not
defined by means of dynamic formulas.