Formula for product based on criteria?

[Guest]

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

 

[Guest]

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

 

[T. Valko]

Try this:

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

 

[Guest]

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

 

[T. Valko]

You're welcome. Thanks for the feedback!