Compare 2 Lists with the MATCH Function

Oct 12, 2013

A question that always gets asked on my Excel courses whenever I cover VLOOKUP is “I have 2 lists. There are some items that are the same on both lists. But there are some items on list 1 that aren’t on list 2. How can I quickly identify these?” The...