Defining area codes per state to sort

  • Thread starter Thread starter jshgolf
  • Start date Start date
J

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.
 
Back
Top