Long List Comparison Made Easy
Say you have two very long lists of data, for example, a list of identification numbers for employees eligible for bonuses and a list of identification numbers for employees eligible for leave increases. You need to see where they match and where they deviate, so you can create three distinct email lists: Bonus recipients, leave increase recipients, and both bonus and leave increase recipients.
You could use your trusty eyeballs of course, or you could save oodles of time with the Excel VLOOKUP function. Check out this video to learn how.