Formula so if reference is selected, a specific value is returned.

B

Boss

A list with 5 different scenarios each have a specific value next to them.
When a dropdown list with all 5 scenarios is opened and one scenario is
selected, the relevant value appears in an adjacent cell.
 
M

Max

A vlookup pointing to the dropdown list's cell would be one way

Eg Assuming dropdown cell is D1, then you could place in E1
=IF(D1="","",VLOOKUP(D1,{"Scenario1",20;"Scenario2",14;"Scenario3",18;"Scenario4",17;"Scenario5",13},2,0))
 
Top