Need to find data from one worksheet in another worksheet.

I have a worksheet of roughly 10,000 voters that have replied to a recent election with just there names and addresses and has 7 columns. I need to find them in another worksheet that has roughly 500,000 voters which has all of there voter information about 200 columns. The 7 columns from the first worksheet are the first columns 7 columns in the bigger list. I have tried hlookup and it didnt work the way I was expecting. Is there an easier way to find them or is there a program that will do it.

Please help.

Thank you.

Please add the excel sheet

I cant just release it on the internet its got social security numbers, voter id numbers, phone numbers, addresses, vote history. Its a felony.

provide a demo version which does not have real time data..as SSN field have
ssn1,ssn2

There are a lot of spaces in the names and initials of "Returned" that are not in the Voter list.

I copied the Returned worksheet and pasted into the Voter Demo workbook and then renamed that sheet as Returned and I renamed the sheet1 of the Voter demo as Voter.

I inserted a column to the left of the existing column A of both worksheets and then on the Voter worksheet entered this formula in A2 and copied down the length of the data:

=IF(COUNTIFS(Returned!B:B,B2,Returned!C:C,C2,Returned!D:D,D2,Returned!E:E,E2)>0,1,"") This will enter a 1 in column A of Voter if the first 4 columns are an exact match.

I hope that the data in the actual voter and returned worksheets are formatted exactly the same because your examples were not the same at all even for the first 4 columns as all the entries of the Returned_demo had trailing spaces for all the text entries while the entries in the Voter list did not have the trailing spaces....trailing spaces will cause formulae to fail when making comparisons.

I went in and cleaned up the worksheet so the formats matched and used what you said and it helped quite a bit. Thank you.