drop down list populates data in another cell

[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.

 

[JBeaucaire]

That's a standard VLOOKUP formula. I presume you have a list somewhere
with these items and prices? Try VLOOKUP in this format to specifically
get the data:

Sheet2=Column A - your items
Sheet2=Column B - your prices
Sheet2=Column C - item codes
A1= your drop down selection (perhaps on sheet1)

=VLOOKUP(A1,Sheet2!$A$2:$C$100,_2_,FALSE) -gets price
=VLOOKUP(A1,Sheet2!$A$2:$C$100,_3_,FALSE) -gets item code

 

[T. Valko]

Same site, different technique:

http://contextures.com/xlFunctions02.html

 

[Shane Devenshire]

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.

 

[JBeaucaire]

Understood. I am just now being made aware how helping on one way is
screwing up things down the line, so I'll stop doing that. Oh well.