Thread: Formula so if reference is selected, a specific value is returned.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
  
Posts: 9,221
Default 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.

Reply With QuoteReply With Quote