IFS in data validation with drop down

[chase_chap81875]

Hello,

I am trying to make an ifs statement that works with data validation.

I want it to be:

IFS(A1="Location1","Fred",A1="Location2","Mike",A1="Location3", *drop down of 3 names*)

(If A1= Location 1 then A2 autopopulates to Fred, same with location 2 and Mike, Location 3 I want a drop down of 3 names in A2)

Any ideas on how it would be able to work?

Thanks!

[#2]

With formulas, the “auto populate” part of you requirement cannot be done. An alternative would be to have “Fred”, “Mike”, or the 3 Names in the drop-down list. In any case, you have to select the name from the drop-down list.