Home

Excel drop down lists

%3CLINGO-SUB%20id%3D%22lingo-sub-315235%22%20slang%3D%22en-US%22%3EExcel%20drop%20down%20lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-315235%22%20slang%3D%22en-US%22%3E%3CP%3EWith%20a%20drop%20down%20list%20how%20do%20I%20link%20each%20one%20to%20a%20series%20of%20formulas%20whilst%20keeping%20the%20original%20labels%20of%20the%20drop%20down%20list%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-315235%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
nickap-162_
Occasional Visitor

With a drop down list how do I link each one to a series of formulas whilst keeping the original labels of the drop down list?

1 Reply
Hi! Try it with scenarios with different formulas within the same range of calculations. It’s no coding solution and gives you better performance. For this go to „data“ tab, in right side there is a button in a group like „if then cases“.. Szenario Manager will help you for sure.

Greets, Eva
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies