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.