Home

IFS in data validation with drop down

%3CLINGO-SUB%20id%3D%22lingo-sub-615841%22%20slang%3D%22en-US%22%3EIFS%20in%20data%20validation%20with%20drop%20down%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-615841%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20make%20an%20ifs%20statement%20that%20works%20with%20data%20validation.%3C%2FP%3E%3CP%3EI%20want%20it%20to%20be%3A%3C%2FP%3E%3CP%3EIFS(A1%3D%22Location1%22%2C%22Fred%22%2CA1%3D%22Location2%22%2C%22Mike%22%2CA1%3D%22Location3%22%2C%20*drop%20down%20of%203%20names*)%3C%2FP%3E%3CP%3E(If%20A1%3D%20Location%201%20then%20A2%20autopopulates%20to%20Fred%2C%20same%20with%20location%202%20and%20Mike%2C%20Location%203%20I%20want%20a%20drop%20down%20of%203%20names%20in%20A2)%3C%2FP%3E%3CP%3EAny%20ideas%20on%20how%20it%20would%20be%20able%20to%20work%3F%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-615841%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Edata%20validation%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-617719%22%20slang%3D%22en-US%22%3ERe%3A%20IFS%20in%20data%20validation%20with%20drop%20down%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-617719%22%20slang%3D%22en-US%22%3EWith%20formulas%2C%20the%20%E2%80%9Cauto%20populate%E2%80%9D%20part%20of%20you%20requirement%20cannot%20be%20done.%20An%20alternative%20would%20be%20to%20have%20%E2%80%9CFred%E2%80%9D%2C%20%E2%80%9CMike%E2%80%9D%2C%20or%20the%203%20Names%20in%20the%20drop-down%20list.%20In%20any%20case%2C%20you%20have%20to%20select%20the%20name%20from%20the%20drop-down%20list.%3C%2FLINGO-BODY%3E
chase_chap81875
New 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!

1 Reply
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.
Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
202 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies