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!
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!