Cell value dependant on dropdown list choice in another cell

**Steveo251** · 01-28-2013, 02:52 PM

Hello, I'm working on a pricing sheet for our company and I need a dropdown list that offers multiple choice to our estimator for types of stocks.
Once he selects the type of stock, I need that choice to pull a price from another list of cells.

For example if the dropdown list has the following choices:
Vinyl
Foam Core
Board
Paper

I need him to chose vinyl in that cell and have the price per inch in another cell change to $0.010.
If he is to choose foam core, the price per inch in that other cell will change to $.0.050.
If he chooses board, the price in the other cell changes to $0.010.

I need to have about a dozen different choices and I'm sure that number will increase over time.

Any suggestions.... thank you in advance.

**Ace_XL** · 01-28-2013, 03:03 PM

This thread should help

http://www.ozgrid.com/forum/showthread.php?t=151735

**Steveo251** · 01-28-2013, 03:43 PM

Hello Ace_XL,
Thank you for your suggestion, but...

From what I can see these create dropdowns with dependant dropdowns based on what is selected in each.

I need to be able to make a selection from a dropdown and based on that selection, it places a specific piece of data in another cell.
So if dropdown choice 1 is selected, it places a certain price in a different cell, lets say E5.
If dropdown choice 2 is selected, it places a different price in the same cell as above E5.
If dropdown choice 3 is selected, it places yet a different price in E5.

So there would be multiple choices in the dropdown and depending on the one chosen, E5 would be filled automatically with the price associated with the dropdown option picked.