drop down list populates data in another cell

  • Thread starter Thread starter Amanda H
  • Start date Start date
A

Amanda H

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.
 
Hi JBeaucaire,

Just as you bold formatting put *'s around parts of your formulas now we are
seeing underscores around the column references for the VLOOKUP formulas.
Although the advanced users may have no problem with this, if may drive the
newer users crazy trying to figure out why a formula like

=VLOOKUP(A1,Sheet2!$A$2:$C$100,_2_,FALSE) doesn't work. Note this displays
on the web interface as underscore2underscore.
 
Back
Top