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.