drop down cells

%3CLINGO-SUB%20id%3D%22lingo-sub-1745063%22%20slang%3D%22en-US%22%3Edrop%20down%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1745063%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20have%20a%20cell%20with%20a%20drop%20down%20menu%20and%20I%20need%20to%20get%20another%20cell%20to%20changed%20for%20the%20different%20items%20on%20the%20menu%20how%20can%20I%20do%20this%20(there%20is%20a%20different%20formula%20for%20each%20drop%20down%20item)%3C%2FP%3E%3CP%3Ethank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1745063%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1745143%22%20slang%3D%22de-DE%22%3ESubject%3A%20drop%20down%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1745143%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F820331%22%20target%3D%22_blank%22%3E%40rdrain%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CH1%20id%3D%22toc-hId-556103146%22%20id%3D%22toc-hId-556103146%22%20id%3D%22toc-hId-556103146%22%20id%3D%22toc-hId-556103146%22%3ECreate%20a%20drop-down%20list%3C%2FH1%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-gb%2Foffice%2Fcreate-a-drop-down-list-7693307a-59ef-400a-b769-c5402dce407b%3Fui%3Den-us%26amp%3Brs%3Den-gb%26amp%3Bad%3Dgb%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-gb%2Foffice%2Fcreate-a-drop-down-list-7693307a-59ef-400a-b769-c5402dce407b%3Fui%3Den-us%26amp%3Brs%3Den-gb%26amp%3Bad%3Dgb%3C%2FA%3E%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%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1745315%22%20slang%3D%22en-US%22%3ERe%3A%20drop%20down%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1745315%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F820331%22%20target%3D%22_blank%22%3E%40rdrain%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESwitch%3F%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fswitch-function-47ab33c0-28ce-4530-8a45-d532ec4aa25e%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fswitch-function-47ab33c0-28ce-4530-8a45-d532ec4aa25e%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20have%20the%20drop-down%20in%20A1%3CBR%20%2F%3EYou%20could%20have%20something%20like%20this%20in%20your%20%E2%80%9Ctarget%E2%80%9D%20cell.%3CBR%20%2F%3E%3DSWITCH(A1%2C%22x%22%2C%E2%80%9DFormula1%E2%80%9D%2C%22y%22%2C%E2%80%9DFormula2%22)%3CBR%20%2F%3Eexample%3CBR%20%2F%3E%3DSWITCH(A1%2C%22x%22%2CE1%2BF1%2C%22y%22%2CE1*F1)%3CBR%20%2F%3EThe%20%E2%80%9Ctarget%E2%80%9D%20will%20show%20the%20result%20of%20different%20formulas%20depending%20on%20what%20you%20chose%20in%20the%20dropdown%20(x%20or%20y)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hi,

I have a cell with a drop down menu and I need to get another cell to changed for the different items on the menu how can I do this (there is a different formula for each drop down item)

thank you

3 Replies
Highlighted

@rdrain 

 

Create a drop-down list

https://support.microsoft.com/en-gb/office/create-a-drop-down-list-7693307a-59ef-400a-b769-c5402dce4...

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

Highlighted

@rdrain 

Switch?

https://support.microsoft.com/en-us/office/switch-function-47ab33c0-28ce-4530-8a45-d532ec4aa25e

 

If you have the drop-down in A1
You could have something like this in your “target” cell.
=SWITCH(A1,"x",”Formula1”,"y",”Formula2")
example
=SWITCH(A1,"x",E1+F1,"y",E1*F1)
The “target” will show the result of different formulas depending on what you chose in the dropdown (x or y)

Highlighted
If I can recommend you, add a file (without sensitive data) and describe your plan on it. This means that you can be helped more quickly and the best possible solution tailored to your needs can be offered. So everyone is helped.
Help to be helped.

* It's always good to add your operating system and Excel version.

Nikolino
I know I don't know anything (Socrates)