Connecting text to numbers

I am trying to create a spreadsheet that calculates prices for customers. I have already created a dropdown menu which displays the items being sold. Now what I need to do is have whatever is selected in the dropdown menu return a numerical value in another cell. Next I need to connect the that value with the next dropdown menu and have that recalculate a new price in a the cell. Example:

First item in drop down menu: A, B, C, D,

If I select A, a price will show up in the next cell

Next item dropdown menu: 1, 2, 3, 4,

If I pick 2, another number will show up in the cell and would be A(price)+2(price).

Is that possible in Excel? If not does anyone know what software can do that?

Column 1
R40=$10,000
R60=$30,000
R200=$75,000

Column 2

W5=$15,000
W10=$25,000
W25=$30,000

I hope that's what you mean by sample data. I apologize if it isn't. I'm new to this and I'm trying to impress my boss

Hi Microsoftnovice

Try this link, would this be what you require!

DATA VALIDATION + INDIRECT and OFFSET

Kevin