Same site, different technique:

http://contextures.com/xlFunctions02.html

--
Biff
Microsoft Excel MVP


"Amanda H" wrote in message
...
I'm am creating a spreadsheet that has a drop down list to select a
specific
product and I want the selection from the list to automatically generate
data
for that product in another cell.

For example:
Cell A2 Drop down list will offer:
Mirror 1
Mirror 2
Mirror 3

If Mirror 1 is selected I want a certain dollar amount to appear in cell
D2.
If Mirror 2 is selected a different dollar amount will appear in D2, etc.

I've reviewed this link: http://contextures.com/xlDataVal02.html
but I'm not sure that is what I am looking for.

Any suggestions would be appreciated.