Ok, this is what I have...

I have 2 excel files each are half of a phonebook (with names and addresses) and 9 files of of just phone numbers sorted by prefix. All of the hyphens have been removed from the phone numbers.


What I need...
I need to take the phonebook files and compare them with the phone numbers that are sorted by prefix and flag or highlight the duplicates.


Can anyone help me? I really have no idea what to do