Conditional Formula
 

I have two worksheets
Worksheet 1 has the main information
Column A1: M Column B1: $12.5
Column B1: S Column B2: $17.00

Worksheet 2 has a value of M or S in column B and a number in column A

I want to have the formula look up the letter in Column B worksheet 2 for a
match in Worksheet 1 and determine if it is an M or S and then return the
value of $12.50 or $17 and then multiply it by column A in Worksheet 2.

The answer will be in Workseet 2.