I have two different data lists that I need to compare to see if information
from one list also appears in the second. The unique identifier (similar to
a social security number) appears in column C of both spreadsheets. Is there
any way that I can write a formula that will give me an output of "Yes" if
the data appears in spreadsheet 1 but not in spreadsheet 2?