Learn Excel Episode 290: Comparing Lists
I use this trick all of the time. Say that you have two versions of a list. You have the current version and an old version. You want to see what changed between the two versions. Rather than try to build complicated VLOOKUP formulas, use a simple pivot table to compare the two lists. Episode 290 shows you how.