Drop Down Menu reference (IF)

Hello,

I have created a drop down menu in a column labeled "Materials" (Column A). From the drop down you choose a material. I then want the letter value of the material to effect the equation in a different column (Column G).

I think that the way to do this is with a IF equation but I am not sure how to write it.
EX) IF A=C, then G=F x value of C. Which is in a different location. How do I reference the value associated with selection from the drop down menu?

Thanks for you time!


Excel help.xls

The reason you are returning an error in F10 is you need a double quote about your text
=IF(A10="C", E10*P10)

however, this formula is multiplying the weight of Type CP not Type C - is this an error

I believe the formula you want in F10 is
=INDEX($O$8:$P$14,MATCH(A10,$O$8:$O$14,0),2) * E10