IF Formula

[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

[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?
--
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

[Todd Nelson]

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

[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)


"Todd Nelson" <ToddNelson@discussions.microsoft.com> wrote in message
news:A8477F3A-48D2-4849-B1A4-11B98EB92247@microsoft.com...
> 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