SOLVED

Formula drop down response

%3CLINGO-SUB%20id%3D%22lingo-sub-2152942%22%20slang%3D%22en-US%22%3EFormula%20drop%20down%20response%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2152942%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20all%2C%3C%2FP%3E%3CP%3EAm%20trying%20to%20create%20a%20response%20in%20adjacent%20tab%20to%20option%20taken%20from%20drop%20down%20box%20with%203%20options.%3C%2FP%3E%3CP%3EHave%20been%20trying%20IF%20function%20but%20not%20working.%3C%2FP%3E%3CP%3EAny%20help%20much%20appreciated.%3C%2FP%3E%3CP%3ECheers%2C%3C%2FP%3E%3CP%3EStephanie%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2152942%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2153030%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20drop%20down%20response%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2153030%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F973562%22%20target%3D%22_blank%22%3E%40Stephanie_Pap%3C%2FA%3E%26nbsp%3BTry%20XLOOKUP%20or%20VLOOKUP.%20Have%20included%20both%20options%20in%20the%20attached%20file.%20Note%20that%20I%20added%20one%20more%20named%20range%20called%20%22Action%22.%20This%20is%20to%20be%20consistent%20with%20your%20use%20of%20the%20named%20range%20%22Status%22.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2153239%22%20slang%3D%22de-DE%22%3ESubject%3A%20Formula%20drop%20down%20response%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2153239%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F973562%22%20target%3D%22_blank%22%3E%40Stephanie_Pap%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFormula%20in%20english%3A%20%3DIF(C2%3D%24I-3.%24J-3%2CIF(C2%3D%24I-4%2C%24J-4%2CIF(C2%3D%24I-5%2C%24J-5%2C%22)))%3C%2FP%3E%3CP%3EFormula%20in%20German%3A%20%3DIF(C3%3D%24I-3%3B%24J-3%3B%20IF(C3%3D%24I%244%3B%24J%244%3B%20IF(C3%3D%24I-5%3B%24J-5%3B%22%22)))%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EThe%20example%20is%20included%20in%20the%20inserted%20file.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20wish%20you%20continued%20success%20with%20Excel%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20Kindly%20Mark%20and%20Vote%20any%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello all,

Am trying to create a response in adjacent tab to option taken from drop down box with 3 options.

Have been trying IF function but not working.

Any help much appreciated.

Cheers,

Stephanie

 

4 Replies

@Stephanie_Pap Try XLOOKUP or VLOOKUP. Have included both options in the attached file. Note that I added one more named range called "Action". This is to be consistent with your use of the named range "Status".

best response confirmed by Stephanie_Pap (New Contributor)
Solution

@Stephanie_Pap 

 

Formula in english:  =IF(C2=$I$3,$J$3,IF(C2=$I$4,$J$4,IF(C2=$I$5,$J$5,"")))

Formel in Deutsch:  =WENN(C3=$I$3;$J$3;WENN(C3=$I$4;$J$4;WENN(C3=$I$5;$J$5;"")))

 

The example is included in the inserted file.

 

 

I would be happy to know if I could help.

 

I wish you continued success with Excel

 

Nikolino

I know I don't know anything (Socrates)

 

* Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.

Thanks @NikolinoDE... appreciate this so much, works perfectly.

Will keep in my arsenal! 

I was happy to help you.
You are welcome