This is one of those things I get asked about on a regular basis. It is when someone has two lists and they need to check that they have the same data. It could be an old list that needs to be compared to a new list. It would be tedious to do this one by one just visually when you can use the VLOOKUP function in Excel to do the work for you. In the video below I show you how to do this.