Forum Discussion
IFS in data validation with drop down
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= Locat...
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.