If you need to reconcile batches of records in Microsoft Excel, this simple VLOOKUP() solution offers a quick and easy way to find records in one batch that are missing from another.

Excel MATCH is a Lookup and Reference function to search for specific items in a range of cell & return the relative position of that item in the range.

You probably use VLOOKUP() function to find exact matches in Microsoft Excel, but you can also find the closest value when you don't know the exact value.

In Excel, you can create relationships between two tables based on the matching data within the table. Learn how to create relationships between tables in Excel.