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.

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


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=45527

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.

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.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"JBeaucaire" wrote:


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


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=45527

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.


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=45527