Area code funtion help

  • Thread starter Thread starter Ultimate
  • Start date Start date
U

Ultimate

I want to be able to put a telephone area code into a cell in one column
and have it return the correct state and time zone in two other cells
in two other columns.
I have seen this function on a sheet but it was programed in a way that
I could not figure out. I would either like a simple formula or
function that I can just put into the column or cell.
I do not have any programming experience under my belt and the simpler,
the better.

Thanks.
 
Hi Ultimate,

You need to create a table somewhere that lists all the
data:

AA AB AC
1 AC ST TZ
2 412 PA EST
3 724 PA EST
4 201 NY EST

Now then, say you want to enter the area code in A1 and
have the other info come up in cells B1 and C1. Use a
formula like this:

B1 =VLOOKUP(A1,AA1:AC4,2,0)
C1 =vLOOKUP(A1,AA1:AC4,3,0)

Check XL help on VLOOKUP

Biff
 
Back
Top