I need a formula to determine the difference between two lists.
Eg: Column A has a bunch of stuff in it:
Column B has a bunch of stuff as well:
I need to find out things that exist in both columns. Column B is much longer, otherwise I'd just sort by name and use my eyeballs. I'm farting around with VLOOKUP but I can't seem to sort (har har) it out.