In Excel, finding differences between two data sets is not that difficult. It is such an easy task with VLOOKUP function. In this tutorial, we are going to learn a practical demo to find the missing or different values in Excel. If you do not know VLOOKUP function, it is better to learn it first by accessing VLOOKUP function, then come here and learn this Excel trick.

As an additional learning, we are also going to use Conditional Formatting here to find out the Missing Data. As always, we have included the practice Excel file for this tutorial for you to practice the same along with the tutorial.