This possible? (if statement problem)

[Kerkain]

Cells A2:A13 are the names of the month. Cells B2:B13 are the amount of weeks I can get paid in that month.

I want cell A1 to show a formula thats basically: if the current month is equal to a month in A2:A13 then display the number that corresponds with the month in B2:B13.

Suggestions?

 

[njimack]

=index(b2:b13,match(a1,a2:a13,0))

 

[Jonmo1]

It's going to depend on exactly what is in A2:A13..
Jan Feb
Or
January February
Or
1/1/2011
2/1/2011
3/1/2011
etc...


If you have TEXT strings January February etc in A2:A13, then try

=VLOOKUP(TEXT(TODAY(),"mmmm"),A2:B13,2,FALSE)


Hope that helps.

 

[jeffreybrown]

One way

=SUMPRODUCT(--(A2:A13=TEXT(TODAY(),"mmm")),B2:B13)

 

[Kerkain]

@jonmo1: The vlookup formula worked perfectly, far as I can tell at least.

@jeffreybrown and @njimack: When I put in your guys' formulas I got an error. In all honesty, I haven't ever made formulas like that either so I don't even know how to change them, lol.

Thanks for the help guys, I appreciate it!

 

[Jonmo1]

Glad to help...

Come to think of it though, I way over complicated it..
If your months are in chronological order...
A2 = January
A3 = February
A4 = March
etc..

Then you can just index column b using the month number..
Don't need to refer to column A.

=INDEX(B2:B13,MONTH(TODAY()))

 

[Kerkain]

That works. I'll use both heheh.

Time for some more research though so I can better understand that formula too.

Thanks.