IF Formula
 

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

=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?
--
paul
remove nospam for email addy!



"Todd Nelson" wrote:

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

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

"paul" wrote:

=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?
--
paul
remove nospam for email addy!



"Todd Nelson" wrote:

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

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

=OFFSET($A$2,,MATCH(A1,{"January";"February";"Marc h";"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";"M ay";"June";"July";"August";"September";"October";" November";"December"},0)

or

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

--
Regards,

Peo Sjoblom

(No private emails please)


"Todd Nelson" wrote in message
...
Is there a way to pull any of the months. If(A1=january,a2),IF
A1=february,
b2), etc for the year??

"paul" wrote:

=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?
--
paul
remove nospam for email addy!



"Todd Nelson" wrote:

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