drop down list populates data in another cell

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filtered drop down list 2
Change drop down list in one cell based on values in other cells 2
Limiting selection in a cell AND linking that selection to a list 1
Create Drop Down Box populated by a List 1
Formulas with drop down list data 1
Customise drop down list validation 3
Drop Down List 2
how to show data in another cell from a drop down box 3

Top