Excel Function : VLOOKUP

Download now!

Excel Function : VLOOKUP


Lookup and reference


Looks in the first column of an array and moves across the row to return the value of a cell

Microsoft Excel Reference Page


Syntax and Description of the VLOOKUP Excel Function

The syntax for the VLOOKUP function in Microsoft Excel is as follows: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) The function takes the following arguments: lookup_value (required): The value to look up in the first column of the table array. table_array (required): The array of values in which to look up the lookup value. col_index_num (required): The column number in the table array from which to return a value. The first column in the table array is considered column 1. [range_lookup] (optional): A logical value that

About VLOOKUP Excel Function

The VLOOKUP function in Excel can be used to lookup and retrieve data from a specific column in a table. The function takes two arguments: the value to be looked up, and the column number in the table to search. VLOOKUP can be used with wildcards to find approximate matches.