I would like to multiply 2 cells, the first contains a drop down list of
product numbers and the second cell contains a different list of product
numbers.

each product number needs to be replaced with an efficiency and then
multiplied.

For example

=SPR-205 * SPR-3300x

Should be

=189 * .945

I thought of an IF statement but it would be way to long. Right now I have
all the product numbers listed in one Column and the Efficiencies in another
Column.