Excel drop down lists

[nickap-162_]

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?

[#2]

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