Finding Values in one random list, highlighting, and labeling based on a known list

Hey Guys,

I have three tabs, my cell phone bill on two tabs (talk and text), and then my address book on the third. The are all formated exactly the same using a guys VBA (thank you poster!). I would like to conditionally format all of my calls text on the first two tabs showing which are in my phone book.

Here is 3rd tab: Phone Book

Screen Shot 2013-05-13 at 4.37.55 PM.png

More than the highlight above I would like to highlight and add text to an adjacent column. I want any of the values here that match the phonebook tab to be highlighted and if possible in the column adjacent they name copied. so the function would say 9-2500 is in the list as "Chase Bank", and would highlight 9-2500 and then add the words "Chase Bank" to the empty column next to it.

Here is the calling record. I want any of the values here that match the phonebook tab to be highlighted and if possible in the column adjacent they name copied.

Screen Shot 2013-05-13 at 4.37.05 PM.png

The result should be similar to |9-2500| Chase Bank|

I found a video that showed something similar using the named range. In Excel for Mac I think is the Insert Name pictured below but it is always grayed out. Any clues? I tried to change the ribbon?

Screen Shot 2013-05-13 at 4.50.54 PM.png

Please edit your post and delete paragraphs #2,#3 & #4 (personal comments/hard to read). Give an accurate description of your problem and post a workbook.
To Attach a Workbook:
1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit

----------------------------
Rule 1 - Thread Titles
Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.