Pull in a colum of financial data based on the month

B

Bradon

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.
 
B

Biff

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top