Posted to microsoft.public.excel.misc
|
|
Formula so if reference is selected, a specific value is returned
See this:
http://contextures.com/xlFunctions02.html
--
Biff
Microsoft Excel MVP
"Boss" wrote in message
...
From a dropdown list I want to select from a range of set levels that have
specific values beside them. So when the range (0 - 600) is selected, $500
appears in another cell.
eg: 0 - 600 $500
600 - 1200 $1000
|