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

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.

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

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))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Boss" wrote:
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.