Sounds like you need a lookup table. See this:

http://contextures.com/xlFunctions02.html

--
Biff
Microsoft Excel MVP


"silverlining" wrote in message
...
I am creating a billing sheet and I have created a drop down list in b7.
What I would like to do is have what ever selection from the drop down
list
have the price connected to d7. So Shrimp cocktail from the app list in
B7
and the price of 350 in D7. Any takers????