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