auto fill state and city from phone number?

Without posting your specific situation, you might only get general responses, like 'use a lookup table'.

Do you have:
•A separate listing of all phone numbers and corresponding addresses?
•Listings of Area Codes/Regions, Prefixes/Cities, etc?
(Note: that with portable phone numbers, prefixes may not accurately refer to Cities?
•Any other information to help with a solution?

Regards,
Ron

Hi Ron-
Yes, I have a separate listing of area codes and their corresponding city & state. How could I set up document A's columns to consult the second document to autofil the City and State fields?

Thanks,

Biz