IFS in data validation with drop down

Copper Contributor

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!

0 Replies