Home

Excel drop down lists

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
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies