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

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

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