See this:

http://contextures.com/xlFunctions02.html

--
Biff
Microsoft Excel MVP


"wcurtis" wrote in message
...
I want a cell to return a value after you select an item from drop down
list.
My drop down lists are in column B and the cell I need to populate is in
colmun F.
Thanks in advance.