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