If/Then Formula Question

Hello I am looking for help writing an IF Then Formula. I am putting together a 3D Printing Cost Recording Sheet. Basically what I want is to type the specific material in one column (such as PLA or ABS), type the weight of the material in another column, and have another column multiply the weight by the Unit weight (this unit weight will not be shown in the excel sheet). There will be 5 materials with 5 unique price per gram numbers. Can anyone help me with this?

Here is an example.
Material Weight Cost
PLA 23g (Need This) The price per gram for PLA is 0.0666/gram. The weight will end up being (23*0.0666). I need the formula to do this automatically for me when I type in PLA. If I were to type NYLON instead of
PLA, it should be (23*0.093).

Assuming your price in column B below is the formula.

=IF(A1="PAL",B1*0.0666,B1*0.093)

Originally Posted by Tony Valko

If not in a table on a sheet it will still be in the formulas.

Need more clarification.

I wanted to have the unit prices in the formula and not in a table on a page. That is all I meant.

Just a slight change to Richard's formula:

=LOOKUP(A2,{"Nylon","PLA"},{0.093,0.066})*B2

The items in the first array list need to be in alphabetical order (and the items in the second list need to correspond with those in the first list).

Hope this helps.

Pete

Pete's Response was exactly what I needed. Thanks for the timely responses everyone.