In this tutorial, I’ll show you how to use VLOOKUP() in Excel to find missing records in one data set when compared to a comprehensive list. Fortunately, it’s not as hard as you might think. SEE: Microsoft Excel: Become an expert with this online training (TechRepublic Academy)įor example, in Excel, you want to compare a set of incoming purchase orders to a comprehensive list of distributed purchase orders. But what if you want to compare two sets of data in Excel to determine if a record is missing from one of the sets? Sometimes the solution finds duplicates across one or more columns sometimes the solution focuses on finding unique values. In Microsoft Excel, I have used many different solutions to compare lists. For more info, visit our Terms of Use page. This may influence how and where their products appear on our site, but vendors cannot pay to influence the content of our reviews. We may be compensated by vendors who appear on this page through methods such as affiliate links or sponsored partnerships. 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. How to find missing records using VLOOKUP() in Microsoft Excel
0 kommentar(er)
