Hey guys,

I have this formula which works fine, but I wan't to see if it can be simplified.

=IF($A$1="JAN",[CUISPremiumRecB1.xls]JAN12!$C$13,IF($A$1="FEB",'[CUISPremiumRecB1.xls]FEB12’!$C$13,IF($A$1="MAR",[CUISPremiumRecB1.xls]MAR12!$C$13,IF($A$1="APR",[CUISPremiumRecB1.xls]APR12!$C$13,IF($A$1="MAY",[CUISPremiumRecB1.xls]MAY12!$C$13,IF($A$1="JUN",[CUISPremiumRecB1.xls]JUN12!$C$13,IF($A$1="JUL",[CUISPremiumRecB1.xls]JUL12!$C$13,IF($A$1="AUG",[CUISPremiumRecB1.xls]AUG12!$C$13,IF($A$1="SEP",[CUISPremiumRecB1.xls]SEP12!$C$13,IF($A$1="OCT",[CUISPremiumRecB1.xls]OCT12!$C$13,IF($A$1="NOV",[CUISPremiumRecB1.xls]NOV12!$C$13,IF($A$1="DEC",[CUISPremiumRecB1.xls]DEC12!$C$13,))))))))))))

Ok so what I'm trying to do is:

I work at a credit union and needed to balance our insurance GL's. I have 12 files which I update with information (CUISPremiumRecB1, CUISPremiumRecB2, etc...) and each file will have a lot of sheets, 1 for each month (JAN12, FEB12, etc). Once I've balanced the 12 branches, I need to pull certain information to this sheet, which I give to others to process the postings. Simply this sheet shows which accounts will be debited/ credited. As you can see from the formula above I have A1 where I will type in which month's information I want. So if I put in JAN, the sheet will update with information from my Branch 1's file for January 12.

The thing is I have 12 branches + multiple postings like this for each branch + different months. If I do it like this, it will take a long time. I would have to edit the formula for each branch + each year it will have to be edited as well.

Is there any way so Excel can automatically update based on multiple conditions. Per say. I could have multiple cells where I enter information. So A1 could be the branch, B1 could be the month and C1 could be the year.

Eg. A1= Branch 1 B1=January C1=2012

Now I would need Excel to automatically find the file CUISPremiumRecB1 and find the sheet named JAN12 and get the value from C13. Any help would be appreciated.

Thanks.