Referring to dropdown list element with "IF" function

[Fredblack64544]

Dear Excel-Users

I need your advice about referring to a chosen element from a dropdown list.

For example: in "A1" there is dropdown list from which I choose an element. The element  that I had chosen should multiple "B1" with 3. But if I would chosse an other that would multiply with 4. 

My question is that how can I refer to to that changable dropdown element,since Excel does not recognize it. 

[#2]

@Fredblack64544 

Perhaps a VLOOKUP formula, but you should provide much more detailed information, and preferably attach a sample workbook.

[#3]

@Hans Vogelaar The problem is that Vlookup (like other functions) simply dont recognize the elements which are in the dropdown list. I could send a picture with an example,but my experience is that if I send one,that would confuse everything. 

[#4 · Accepted solution]

@Fredblack64544 

Attaching a sample workbook without sensitive date is your best option.

[#5]

You are right,here is an example. If I choose Steel its give 50 for the price, and if I choose the cube shape it will give 5 for the additional cost,which is 55 in total. (In reality I did not referred to steel or the cube just wrote these numbers to cell and it look like that there is a connection between them,its look like that they are depending on each other,while actually they dont.) What I want is that to create an option to the drop down list where I could choose Wood instead of Steel and that would change the material price to 40,and 4 for the additional cost,hich would be 44 in total. Hope you can understand by now.

[#6]

@Fredblack64544 

That is a screenshot of a worksheet, not a workbook.

You'd need to create a lookup list with the various options and their prices.