HDTutorial
EN
Tutorial - Excel - Phone Area Code to State (VLOOKUP)

Playback starts YouTube’s embedded player (privacy-enhanced mode).

Tutorial - Excel - Phone Area Code to State (VLOOKUP)

41,712 views October 25, 2016 7:38

Watch on YouTube
ChannelIlan Patao

Description from the creator

Short tutorial explaining how to take a list of phone numbers and use the VLOOKUP formula to a state codes to the corresponding area code. Some of you who look for a way to easily convert area codes to states locations my find this very useful. I know for my purpose of converting phone numbers to locate which state a caller phoned in from is very useful. Easily done in Excel 2010, 2013 or 2016.

The URL from where I got the states from is:
bennetyee.org/ucsd-pages/area.html

The VLOOKUP formula used in this tutorial is:
=VLOOKUP(VALUE(LEFT(A1,3)),StateCodes,2,FALSE)

If you follow the steps closely this is a great example of using VLOOKUP, defining a table and referencing values to a column. I hope some of you find this useful. Thank you for watching!

About this tutorial

Ilan Patao published this 7:38 video tutorial on October 25, 2016. It has been watched 41,712 times on YouTube.

Channel
Ilan Patao
Category
Education
Duration
7:38
Published
October 25, 2016
Views
41,712
Likes
243

Tags

Share

Further reading

  • using a VLOOKUP to pull area codes out of a phone number ... answers.microsoft.com

    I want to create a vlookup formula that pulls the area code out of a phone number and matches it to a table of area codes and returns an are in the country for that area code. I have tried making sure that the formattin…

  • How to convert phone area-code to state ... - Excel Help Forum excelforum.com

    can use VLOOKUP() on to get the items from you area code table--Gary''s Student "NoYouShmoopie" wrote: > I have a column with US phone numbers (all numerical, 10 digits). I would > like to have the State name in a colum…

  • Excel VLOOKUP Tutorial for Beginners: Learn with Examples guru99.com

    VLOOKUP can help us aggregate all the data so that we can see Employee's Code, Name, and Salary in one place or sheet. We will start our work on Sheet 2 as that sheet provides us with two arguments of the VLOOKUP functi…

This tutorial in other languages