SOLVED

New Contributor

# Formula drop down response

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

# Re: Formula drop down response

@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

# Betreff: Formula drop down response

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.

# Betreff: Formula drop down response

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

Will keep in my arsenal!