look up names in one excel tab to find a match in another tab
 

I have two tabs in an excel worksheet. The first tab is an older list of
names. The last name is in column A and the first name is in Column B. The
second tab is a recent list with new names added that are not on the first
tab, which is an older list. How do I search the names in the 2nd more recent
list to see which names are not on the original list? I need to know what
names have been added on the recent list that are not on the older list.

look up names in one excel tab to find a match in another tab
 

In "recent" worksheet, column C, enter:
=SUMPRODUCT((A1=Sheet1!A$1:A$999)*(B1=Sheet1!B$1:B $999))=0

This will return True if entry not found in "older" list.

HTH
--
AP

"mike" a écrit dans le message de news:
...
I have two tabs in an excel worksheet. The first tab is an older list of
names. The last name is in column A and the first name is in Column B. The
second tab is a recent list with new names added that are not on the first
tab, which is an older list. How do I search the names in the 2nd more
recent
list to see which names are not on the original list? I need to know what
names have been added on the recent list that are not on the older list.