A vlookup is a function in Excel that allows you to look up specific values in a spreadsheet and return the corresponding corresponding values. This makes it easy to organize your data and quickly find the information that you are searching for.
VLOOKUP stands for “vertical lookup”, because it allows you to search for values across columns instead of down rows like traditional lookups.
To perform a vlookup, simply enter the lookup value in the first column of your spreadsheet, then specify which column you want returned by entering either a number or a cell reference into the second argument of the function. You can also specify additional options such as whether or not an exact match must be found, and if comparisons should be made using text or numbers.
In its simplest form, the VLOOKUP function says:
=VLOOKUP(What you want to look up, where you want to look for it, the column number in the range containing the value to return, return an Approximate or Exact match – indicated as 1/TRUE, or 0/FALSE).
Use the VLOOKUP function to look up a value in a table.
VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup])
- =VLOOKUP(A2,’Client Details’!A:F,3,FALSE)
How to get started
There are four pieces of information you’ll need for VLOOKUP syntax construction:
- The value you want to check, also known as the lookup value.
- The column where the lookup value is found. VLOOKUP requires that the lookup value be in the first column of your range. If your lookups value is in cell C2, for example, you should start your range with C.
- The column number in the range that contains the return value. If you want to count from B2:D11, for example, you should start counting with B and continue until D.
- Finally, if you want to make an approximate or exact match of the return value, choose TRUE or FALSE, respectively. If you don’t provide anything, the default value will be true or an approximate match.
Now put all of the above together as follows:
=VLOOKUP(lookup value, range with the lookup value, column number in the range with the return value, Approximate match (TRUE) or Exact match (FALSE))
Here are a few examples of VLOOKUP: