Home

IFS in data validation with drop down

%3CLINGO-SUB%20id%3D%22lingo-sub-615823%22%20slang%3D%22en-US%22%3EIFS%20in%20data%20validation%20with%20drop%20down%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-615823%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-615823%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%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!

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
217 Replies