Can different drop down lists be displayed depending on the value.

[Guest]

Can different drop down lists be displayed depending on the value of another
reference cell?
for example, if A1 = true, then B1 displays drop down list #1, and if A1 =
FALSE, then B1 displays drop down list#2
Thanks for any tip!!

 

[Debra Dalgleish]

There are instructions here for dependent data validation lists:

http://www.contextures.com/xlDataVal02.html

Or, if you only have two choices, you could use an IF formula for the
list, e.g.:

=IF(E3="Yes",List1,List2)