Formula drop down response

[Stephanie_Pap]

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

[#2]

@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".

[#3 · Accepted 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.

[#4]

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

Will keep in my arsenal! 

[#5]

I was happy to help you.
You are welcome