Hello,
Does anyone have a good solution, or know a function, that will deploy VLOOKUP but match each value only once?
For example, List 1 has these items: BOB, JANE, MARY, BILL, SAM.
List 2 has these items: BOB, JANE, MARY, BOB, JANE, MARY.
I want to see which items in List 2 have a match in...