Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pull in a colum of financial data based on the month
I am creating summary reports that compare one financial period to another.
The Budget, Prior Period and Current year are in tables and there is a column for each month. To do this I currently have the below if statement where I am pulling in the months sales from the table. $L$1=the month value (example 1=January). =IF($L$1=1,'Sales Actual 1 of 2'!C7,IF($L$1=2,'Sales Actual 1 of 2'!D7,IF($L$1=3,'Sales Actual 1 of 2'!E7,IF($L$1=4,'Sales Actual 1 of 2'!F7,IF($L$1=5,'Sales Actual 1 of 2'!G7,IF($L$1=6,'Sales Actual 1 of 2'!H7,"error")))))) The formula works, but there has to be a better way to achieve the same result. The formula is to long if you try to write it for all 12 months. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pull in a colum of financial data based on the month
there has to be a better way to achieve the same result.
There is! If you have 12 cells for the months then I'm guessing your range is C7:N7. =INDEX('Sales Actual 1 of 2'!C7:N7,$L$1) Biff "Bradon" wrote in message ... I am creating summary reports that compare one financial period to another. The Budget, Prior Period and Current year are in tables and there is a column for each month. To do this I currently have the below if statement where I am pulling in the months sales from the table. $L$1=the month value (example 1=January). =IF($L$1=1,'Sales Actual 1 of 2'!C7,IF($L$1=2,'Sales Actual 1 of 2'!D7,IF($L$1=3,'Sales Actual 1 of 2'!E7,IF($L$1=4,'Sales Actual 1 of 2'!F7,IF($L$1=5,'Sales Actual 1 of 2'!G7,IF($L$1=6,'Sales Actual 1 of 2'!H7,"error")))))) The formula works, but there has to be a better way to achieve the same result. The formula is to long if you try to write it for all 12 months. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro | Excel Discussion (Misc queries) | |||
Get Data based on Month and Year | Excel Worksheet Functions | |||
How do I change column data based on dynamic (rolling) dates? | Excel Discussion (Misc queries) | |||
combining multiple rows of data into one single row of data | Excel Worksheet Functions | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions |