# How to use Excel VLOOKUP function

## SUMMARY INFO

All the basic information regarding VLOOKUP function in Excel is listed in the table below. (This data is regularly updated from Microsoft and several resources)

 Function: VLOOKUP Function Category: Lookup and reference Description: Looks in the first column of an array and moves across the row to return the value of a cell Return Value: The matched value from a table. Syntax: =VLOOKUP (value, table, col_index, [range_lookup]) Applies to: Excel 2016, Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000 Other languages: English: VLOOKUP French: RECHERCHEV German: SVERWEIS Spanish: BUSCARV Dutch: VERT.ZOEKEN Italian: CERCA.VERT Russian: ВПР Danish: LOPSLAG Swedish: LETARAD Portuguese (Brazil): PROCV Polish: WYSZUKAJ.PIONOWO Finnish: PHAKU Norwegian: FINN.RAD Portuguese (Portugal): PROCV Czech: SVYHLEDAT Hungarian: FKERES Turkish: DÜŞEYARA All Other Languages: VLOOKUP Related Functions: HLOOKUP, MATCH, INDEX

## FUNCTION DETAILS

Syntax details with an example regarding the correct usage of function can be seen below.

### =VLOOKUP (value, table,  col_index, [range_lookup])

value The value to look for in the first column of a table.
table  The table from which to retrieve a value.
col_index
The column in the table from which to retrieve a value.
range_lookup [optional] TRUE = approximate match (default). FALSE = exact match.

## VIDEO EXAMPLES

Check the video below to see How to use Excel VLOOKUP function with some examples:

Here we provide a list of useful links which we think can be useful while trying to learn the function usage with some examples and tips.

A comprehensive guide about usage and troubleshooting of VLOOKUP formulas:

Microsoft Office support page – Excel VLOOKUP function:

23 things you should know about VLOOKUP:

Excel VLOOKUP – Massive Guide with 8 Examples:
http://www.exceltrick.com/formulas_macros/vlookup-in-excel/

A website dedicated to only vlookup formula:
http://howtovlookupinexcel.com/

## EXCEL FORMULAS TRAINER

As said: Practice Makes Perfect!

Test your Excel skills in Excel itself with our unique product: Excel Formulas Trainer.

30 sections and around 100 questions with full hands-on experience. Progress tracking, dashboard, error checking and many more. Check it now: