In a previous article we covered The Basics of VLOOKUP. VLOOKUP is a very versatile function that can be combined with other functions. When you learn to combine VLOOKUP with with other functions it makes it super powerful. In this article we will look at combining VLOOKUP with TEXT functions.
Lets quickly refresh some basics of VLOOKUP
The syntax for VLOOKUP is
VLOOKUP = (lookup value, table array, column index, range lookup)
Lookup value is the value you wish to look up. This value must be in the far most left column of the table
Table array is the table in which you want to search. The first column will always be the column that contains the lookup value.
Column index is the column number you wish to return the data from.
Range lookup offers a true or false selection. Where true is an exact match. This will only return a value where an exact match to the lookup value is found. When using an Approx. match (false), items in the table must be sorted from lowest to highest, or in alphabetical order.
VLOOKUP within TEXT - The Problem
Below we can see two sets of data. The first contains the phone area code with the region and the second contains customer phone number. We want to use the phone number to carry out a lookup and return the region.
Looking at the Customer Phone Numbers, the first 4 digits represent the area code. These values are text. We can recognize they are text because numbers
Posted from my blog with SteemPress : http://theexcelclub.com/how-to-carry-out-a-vlookup-within-text-in-excel/