![](https://xlncad.com/wp-content/uploads/2020/07/VLOOKUP-Function-3-1024x462.png)
Table of Contents
About
The VLOOKUP function is one of the most popular Excel functions. VLOOKUP function can be used to search for a value in table which is organized vertically.
VLOOKUP function supports approximate and exact matching and is a member of Lookup and Reference functions in Excel.
Function Type
Lookup and reference
Purpose
Search for a value or values corresponding to the match in the first column
Return value
Matched value
Syntax
=VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup])
Arguments
lookup_value – value to search for
table_array – The table or range of cells where the VLOOKUP function will search for the lookup_value and the return value
col_index_num – index number of the column containing the return value (first column will be 1, second column 2,..)
range_lookup – [optional] TRUE/1 = approximate match (default). FALSE/0 = exact match
Examples
![](https://xlncad.com/wp-content/uploads/2020/07/VLOOKUP-Function-4.png)
Notes
The XLOOKUP function introduced in Jan 2020 is an improved version of VLOOKUP function.
Excel Functions in Alphabetical Order (Complete list)
Complete List of Excel Functions (Category wise)