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.

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

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"klmiura" wrote:

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.

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

"Shane Devenshire" wrote:

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

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"klmiura" wrote:

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.