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.

Do you have a list of any sort to match up to?

If you have a list of say area codes with cities/states, then you can use formulas to get from that list...

zip it first, then download the zipped file

Here it is. I have a feeling its not doable.

I need the city and state populated in Column I based on the telephone number from Column F.

Thank you thank you thank you.

Edit:

Removed attachment. Please do not post sensitive information. You had phone numbers and email addresses that looked very real. Please respect the confidentiality of other people's personal information.

Hello ,

Welcome to the Forum!

Do you have a table of area codes with the cities and state? If not I found a listing here that can could easily be made into a look up table.

Hello coastieshak,

If you like, I can add the information to your workbook to save you some time. Can you post your workbook?

Hello coastieshak,

You can upload it if you zip the file.