2 tables, whats missing from one that's in the other

I have 2 tables, I have 10,000 rows in one and 8,000 in the other, I am trying to compare what is missing from the other. Sounds easy enough. Just do a look up on a unique variable and done right. Wrong, I have in 'Column D' member_id, which is for a member and each of their family members. Well you ask, what about in 'Column G' you ask, well that is the family last name, 'Column H' that is the individual's first name, and 'Column I' the individual DoB (non work as an individual unique row identifier, the whole family has the same last name, their is the opportunity for multiple people with the same first name, and DoB).

I am trying:

=AND(VLOOKUP(Sheet1!$D3,Sheet2!$C:$U,1,0),VLOOKUP(Sheet1!$E3,Sheet2!$C:$U,19,0),VLOOKUP(Sheet1!$I3,Sheet2!C:U,5,0),VLOOKUP(Sheet1!G3,Sheet2!C:U,3,0),VLOOKUP(Sheet1!$H3,Sheet2!C:U,4,0))

to gather together all the variables (mem_id, mem_ssn, ind_dob, ind_last_name, ind_first_name) to give a unique row evaluation, but I only get #N/A.

Any help or a point in the right direction would be greatly appreciated.

I know this sounds low-tech, but have you sorted by member ID numbers on each sheet, and just manually gone through and inserted rows where they don't match? In the end, if I'm understanding the problem correctly, that's what will end up happening, anyway. That way, you know you have each individual for each member ID, which could then be modified or a row identifier then added, to make each row easier to search through, later.

Just my $0.02

-Z

Uploaded a short example, what ever the easiest/best way of indicating what is missing from the other table, whether #N/A or whatever. I GREATLY appreciate the help.

with 10,000 rows just on one table to go through to compare to the other table then back to see if any are missing from the other table, not really how I want to spend several days.

=IF(ISNA(VLOOKUP(B2,Sheet2!$B$2:$D$10,3,FALSE)),"MISSING","")
This uses the unique SSN number.

That works, there is only one issue I have now. Since one of the sources was a comma delimited file, I have spaces after the first name and last name. is there a way to remove those without having to go cell by cell to remove?

nvm, I used =trim(clean()) and pasted values. Worked exactly as needed thank you!!