Forum Discussion

chase_chap81875's avatar
chase_chap81875
Copper Contributor
May 20, 2019

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

data validation
excel
Formulas and Functions

1 Reply

  • Twifoo's avatar
    Twifoo
    Silver Contributor
    May 20, 2019
    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.

Resources