At my office when I check my voicemails I use Excel 2000 to create a log
sheet of all voicemails received. Then, I start calling people back.
However, to avoid calling people too early or too late, I want to find a way
to automatically display the STATE and/or TIME of the person I am calling
back.

My log sheet is laid out with a column for names, a column for numbers and
a column for notes.

I could add a column for timezones or states, but I want that field to
automatically populate with the appropriate information based on the
telephone number that I enter in the column of phone numbers.

Is this possible?