How to populate city/state based on telephone number

So I spent 10 hours working on this media list that is about 5000 contacts long.

I have about 5000 phone numbers in Column A. ALL I need is for column B to tell me what City, State those phone numbers are from. Is there any easy formula I can add to have column B populate the city and state based on the telephone number I have provided?

I'm on a strict deadline when I noticed this major screw up. Any help you can provide would help this intern out so much! I've exhausted all my resources in office by the way and nobod has been able to help.