If Statement and Validation Lists

[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 to have
you choose from?

Thanks for your help in advance

 

[Jason Morin]

In an open cell (say E1), use:

=IF(A1="Yes","list1","list2")

where "list1" and "list2" are defined names for your
lists. Now, under validation, select "List", and
under "Custom", put:

=INDIRECT(E1)

HTH
Jason
Atlanta, GA

 

[Guest]

Sorry ur gonna have to expand further I cant get it too
work!