validation-list

[Keyvan]

Dear Sirs,

How may have a validation list depend on other cell?

for example if A1 is 1 then B1 can be: Mike, Jullie, peter; and if A1 is 2
then B1 can be: mary, frank, Jessica.

thank you for your help

 

[Debra Dalgleish]

There are instructions here for creating dependent data validation lists:

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