If/Then Formula Question

Hi,

With your Material in A2 (and this could be data validation drop down cell allowing you to pick one of the 5 materials), and the weight in B2 then in C2 the cost function will be

Formula:

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

obviously extend the two array elements for your other three materials.