VLOOKUP Function


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


Search for a value or values corresponding to the match in the first column

Return value

Matched value


=VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup])


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



The XLOOKUP function introduced in Jan 2020 is an improved version of VLOOKUP function.

Read more on similar functions

Excel UNIQUE function

Excel SORT function

Excel SEQUENCE function

Excel SORTBY function

Excel RANDARRAY function

Leave a Reply

Your email address will not be published.Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.