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.