Formula for product based on criteria?
 

I have a worksheet that looks roughly like the following:
A B C L M
N O
1 Jan Feb March........... to Dec Wage Base
Liability at: XXXXX
2 joe 3 7 88 ........... $100
$______

I am trying to figure out a formula for cell N2 so that if the user types a
"Jan" into cell O1 they will get the product of cell A2*M2. If they type
"Feb" into cell O1 they will get the product of B2*M2...and so on through to
Dec.

Is this possible or do I just need to do 12 "If"'s in the formula? Thanks

Formula for product based on criteria?
 

Sorry when I wrote this all the columns lined up but once it posted it got
all squished and confusing. Columns A to L are Jan to Dec. there are numbers
under each month. I am looking for a formula where I can type a month into
cell O1 and get the product of the number under that month times the Wage
base (M2). Hope that clears it up a bit.

cell N2 would be - =if(O1=Jan,A2*M2, if(O1=Feb,B2*M2) but I need it to
change for every month

"Klee" wrote:

I have a worksheet that looks roughly like the following:
A B C L M
N O
1 Jan Feb March........... to Dec Wage Base
Liability at: XXXXX
2 joe 3 7 88 ........... $100
$______

I am trying to figure out a formula for cell N2 so that if the user types a
"Jan" into cell O1 they will get the product of cell A2*M2. If they type
"Feb" into cell O1 they will get the product of B2*M2...and so on through to
Dec.

Is this possible or do I just need to do 12 "If"'s in the formula? Thanks

Formula for product based on criteria?
 

Try this:

=HLOOKUP(O1,A1:L2,2,0)*M2

--
Biff
Microsoft Excel MVP


"Klee" wrote in message
...
I have a worksheet that looks roughly like the following:
A B C L M
N O
1 Jan Feb March........... to Dec Wage Base
Liability at: XXXXX
2 joe 3 7 88 ........... $100
$______

I am trying to figure out a formula for cell N2 so that if the user types
a
"Jan" into cell O1 they will get the product of cell A2*M2. If they type
"Feb" into cell O1 they will get the product of B2*M2...and so on through
to
Dec.

Is this possible or do I just need to do 12 "If"'s in the formula? Thanks

Formula for product based on criteria?
 

This is great thanks very much. Exactly what I needed.

"T. Valko" wrote:

Try this:

=HLOOKUP(O1,A1:L2,2,0)*M2

--
Biff
Microsoft Excel MVP


"Klee" wrote in message
...
I have a worksheet that looks roughly like the following:
A B C L M
N O
1 Jan Feb March........... to Dec Wage Base
Liability at: XXXXX
2 joe 3 7 88 ........... $100
$______

I am trying to figure out a formula for cell N2 so that if the user types
a
"Jan" into cell O1 they will get the product of cell A2*M2. If they type
"Feb" into cell O1 they will get the product of B2*M2...and so on through
to
Dec.

Is this possible or do I just need to do 12 "If"'s in the formula? Thanks

Formula for product based on criteria?
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Klee" wrote in message
...
This is great thanks very much. Exactly what I needed.

"T. Valko" wrote:

Try this:

=HLOOKUP(O1,A1:L2,2,0)*M2

--
Biff
Microsoft Excel MVP


"Klee" wrote in message
...
I have a worksheet that looks roughly like the following:
A B C L M
N O
1 Jan Feb March........... to Dec Wage Base
Liability at: XXXXX
2 joe 3 7 88 ........... $100
$______

I am trying to figure out a formula for cell N2 so that if the user
types
a
"Jan" into cell O1 they will get the product of cell A2*M2. If they
type
"Feb" into cell O1 they will get the product of B2*M2...and so on
through
to
Dec.

Is this possible or do I just need to do 12 "If"'s in the formula?
Thanks