Excel provides built-in tools to help you to find discrepancies like Filters, Conditional Formatting, advanced functions (If and IS, VLookUp, etc.), and Add-ins.

Fortunately, Excel 365’s Power Query offers a suite of powerful tools to streamline the data cleaning process, allowing you to efficiently prepare your data for analysis.

Fortunately, it’s not as hard as you might think. 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.

In this example, we have been given seven customers to work with. Our starting data set. Note the File menu at the left end of the Excel Ribbon. Shimon Brathwaite/IDG ...

2. Click the Data tab. 3. In the Get & Transform Data group, click From Table/Range. If you haven’t formatted the data as a Table, Power Query will prompt you to do so.