| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula so if reference is selected, a specific value is returned | Excel Discussion (Misc queries) | |||
| limit characters returned a cell reference | Excel Worksheet Functions | |||
| A formula for displaying the cell reference of the selected cell | Excel Discussion (Misc queries) | |||
| Need reference in adjacent column returned | Excel Worksheet Functions | |||
| Specific cell selected when sheet opens...how??? | Excel Discussion (Misc queries) | |||
Hybrid Mode
