Hi,

Let's say that I have two excel tables and both have the same field names which contains data like Name, Social Security Number, Address....and so far. For example:

Table #1

LastName FirstName SSN Address PhoneNumber
Smith John 111-11-1111 123 Usa St. 123-458-9999
Smith Tim 222-22-2222 321 Main St. 123-444-5555

Table #2

LastName FirstName SSN Address PhoneNumber
Smith John 111-11-1111 123 Usa St. 123-458-9999
Smith Tim 222-22-2222 321 Main St. 123-444-5555
Brunell Mark 333-33-3333 444 Usa St. 123-555-9999

Noticed that table #2 has an extra person. Otherwise they are both the same. Now, Is there a way that I can do to make excel to point out that 333-33-3333 does not match any number in the table #1? If yes, please show me the steps to get it done. The above is just a simple example. My tables has hundred of names and it will take forever to check off one by one manually on both table in order to see which table has a data that does not match. Thanks in advance!