Defining area codes per state to sort

[jshgolf]

I'm not sure if "general" is the right category for this question. New to this forum - first thread.

I have a spreadsheet that identifies phone calls made from our company each month (approximately 7000 line items). I am able to spread the phone number out to isolate the area code into one column. My task is to identify what state each area code represents and then total the number of calls per state and also the minutes to each state.

My question is this: I have the area code isolated - and I also have an excel grid with the current area codes with state designations (approx. 317 of them).

How can I automate my grid to automatically ID the area code and tag the state designation into a separate column?

Your help is appreciated.

Hi

One option is to use VLOOKUP. With your area code in A2, and your list of
area codes and states in D2:E318, try something like this: in B2:
=VLOOKUP(A2,$D$2:$E$318,2,FALSE)
This should return the relevant state for you. Once you are happy with this,
you can fill the formula down to complete the rest.

Hope this helps.

--
Andy.


"jshgolf" <[email protected]> wrote in
message news:[email protected]...
>
> I'm not sure if "general" is the right category for this question. New
> to this forum - first thread.
>
> I have a spreadsheet that identifies phone calls made from our company
> each month (approximately 7000 line items). I am able to spread the
> phone number out to isolate the area code into one column. My task is
> to identify what state each area code represents and then total the
> number of calls per state and also the minutes to each state.
>
> My question is this: I have the area code isolated - and I also have an
> excel grid with the current area codes with state designations (approx.
> 317 of them).
>
> How can I automate my grid to automatically ID the area code and tag
> the state designation into a separate column?
>
> Your help is appreciated.
>
>
> --
> jshgolf
> ------------------------------------------------------------------------
> jshgolf's Profile:
> http://www.excelforum.com/member.php...o&userid=24840
> View this thread: http://www.excelforum.com/showthread...hreadid=383903
>

[jshgolf]

Andy,

Thank you for the tip! I just implemented and everything worked out just great!