Conditional Formula

[klmiura]

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.

 

[Shane Devenshire]

Hi,

Not sure about having S and 12.5 in B1? But the basic idea is if you want
the result in C1 of sheet 2
=VLOOKUP(B1,A$1:B$2,2,)*A1

 

[klmiura]

Thank you so much...I thought I did that already, but I must have screwed
that one up....you are a life saver...and quick