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 % 0