Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Need some help with excel. In the screenshot below, I have created 2 drop down lists which each have 3 scenarios: Base, Best, Worst which
Need some help with excel. In the screenshot below, I have created 2 drop down lists which each have 3 scenarios: Base, Best, Worst which are linked to different values. Is it possible to link the drop down lists together so that if I change one of the drop down lists to lets say Best Scenario, the other drop down list also changes to Best Scenario?
Cannibilisation Rate Change BaseScenarioBestScenarioWorstScenario%%%+1.51.5 Average Paid Memberships BaseScenarioBestScenarioWorstScenario%%%+3232 Change in Cannibilisation Rate Base Scenario % 0 Change in Average Paid Memberships Base Scenario % 0 Cannibilisation Rate Change BaseScenarioBestScenarioWorstScenario%%%+1.51.5 Average Paid Memberships BaseScenarioBestScenarioWorstScenario%%%+3232 Change in Cannibilisation Rate Base Scenario % 0 Change in Average Paid Memberships Base Scenario % 0Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started