Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
=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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |