Excel - Find values in List not in other List

You have 2 lists in Column A (smaller list) and Column B (larger list). You want to find values in Col B, that are not in Column A

Here is the formula for doing this :

In Col c, you write = match(B2,A$2,A$350,0)

Doing so, you will see a #N/A next to all values from B that are not found in List A.

Found one more fun thing in excel :)