What is the function of vlookup?

What is the function of vlookup?

The VLOOKUP function is a vertical search function in Excel. It belongs to the same type of function as the LOOKUP function and the HLOOKUP function. It is widely used in work. For example, it can be used to check data and multiple tables. Quickly import data and other functions. The function is to search by column, and finally return the value corresponding to the required query sequence of the column; the corresponding HLOOKUP is to search by row.

The syntax rules of this function are as follows:

VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)

Parameter description

Lookup_value needs to be in the data table. The numeric value to be searched for in a column. Lookup_value can be a numeric value, a reference, or a text string. When the first parameter of the vlookup function omits the search value, it means searching with 0.

Table_array is the data table in which data needs to be found. Use a reference to a zone or zone name.

col_index_num is the data column number used to search for data in table_array. When col_index_num is 1, the value of the first column of table_array is returned. When col_index_num is 2, the value of the second column of table_array is returned, and so on. If col_index_num is less than 1, the function VLOOKUP returns the error value #VALUE!; if col_index_num is greater than the number of columns in table_array, the function VLOOKUP returns the error value #REF!.

Range_lookup is a logical value that indicates whether the function VLOOKUP is an exact match or an approximate match when searching. If FALSE or 0, returns an exact match, or an error value #N/A if not found. If range_lookup is TRUE or 1, the function VLOOKUP looks for an approximate match, that is, if an exact match is not found, the largest value less than lookup_value is returned. If range_lookup is omitted, it defaults to 1.

For more Excel-related technical articles, please visit the Excel Tutorial column to learn!

The above is the detailed content of What is the function of vlookup?. For more information, please follow other related articles on the PHP Chinese website!