I am trying to tie out a reporting layer database that has been designed to tie to a consolidation system using excel. The reporting layer uses legacy ERP system data that is mapped to a consolidation system account. This is a many (stress many) account to one account relationship. I am using a pivot table to summarize the legacy ERP data that has been mapped using a vlookup to a mapping table in order to see a summarized view at the consolidation account level. What I have found after doing a side by side comparison is some of the legacy accounts have been mapped to, for example, office equipment, when they should have been mapped to accumulated depreciation of office equipment because I have a variance of -1000 on equipment, and +1000 on depreciation.

The consolidation system account balance, for example 12,000, for office equipment is correct but is now currently showing 11,000 based on my mapping. What do I need to do in order to find the correct combination of legacy accounts (currently in list form with balances) that equates to the 12,000? Is it looping (which I am not very familiar with)? I had hoped the 1000 +/- error was one or two accounts, but that is not the case so I can't simply look at the list to find the error.