FTC (Federal Trade Commission) Do Not Call List

I have (2) excel 2007 files, the first file is a list of all (334) area codes in which individuals have registared as "Do Not Call" consumers. The next file is a list of residents, address, city and state, zip and Phone numbers. What I'm trying to do is have file #2 look into file #1 and see if the phone number in file #2 matches the do not call ist in file #1, if a match return "registered" to the cell beside the phone number in file #2. Any help would be greatly appreciated.

Hello moodymelton50, and welcome to the forum.

Please notice that I have moved your threads from the "Introduce Yourself" forum. Normally this thread would be left open and your second, duplicate thread, would be closed because the forum rules prohibit duplicate threads. Your second thread, however, has attachments and this one does not so this thread will be treated as the duplicate and will, therefore be closed.

Please read the following rule regarding duplicate threads. Thanks.

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.