Although a running balance is commonly maintained on the same Excel worksheet as the debits or credits, you can also keep a running balance with figures that reside on different Excel sheets.

How to Use VLookup With Different Sheets on Excel. Excel's VLOOKUP function searches an array of cells for data you choose, returning data from the cell next to the one that it finds.

In this post, we will discuss how to find differences or discrepancies in Excel and get a clean data sheet. What does discrepancy mean in Excel?

To use VLOOKUP to find data in another Excel workbook requires multiple workbooks' relevant data. Once you have them, follow these steps.

You load each worksheet into a table in Access and do a join query between/against the two. This will provide the intersection of the two lists.