I have two files,

One is a list of registered voters from a town and the other is a list of utility customers from the same town.

The lists are not formatted identically and not all people who buy utilities are registered and vise versa.

I need to match the phone numbers from the utilities to the voters.

Copying and pasting thousands of entries would take days that I don't have.

I also have Microsoft Access if that could be used.

Here is a screen shot of the two spreadsheets.

I need to get the phone numbers from the bottom to "Phone Match" at the top. (I've already done the data shown but as you can imagine there are many thousands of entry's)

All of this is from public records by the way.

Thank you anyone out there kind enough to help.


screenshot.jpg