IF Formula

T

Todd Nelson

Does anyone know the formula to pull information that corresponds to the
month referred to. I am doing a review spreadsheet and need the numbers to
autofill for the corresponding month. Example. If A1=January, A2, If feb,
b2. I am stuck on this and any help would greatly be appreciated
 
P

paul

=IF(A1="january",A2,"not")
this will display A2 if A1 is text January,but of course you can only nest a
few ifs.Are you really only wanting to display the contents of one cell for
each month?
 
T

Todd Nelson

Is there a way to pull any of the months. If(A1=january,a2),IF A1=february,
b2), etc for the year??
 
P

Peo Sjoblom

If you want what's in cells A2:L2 depending on a text value in A1?

=OFFSET($A$2,,MATCH(A1,{"January";"February";"March";"April";"May";"June";"July";"August";"September";"October";"November";"December"},0)-1)

if you just want the month's index number

=MATCH(A1,{"January";"February";"March";"April";"May";"June";"July";"August";"September";"October";"November";"December"},0)

or

=MONTH(--(A1& "1, 2005"))

--
Regards,

Peo Sjoblom

(No private emails please)
 
Top