Function of vlookup function

Function of vlookup function

The VLOOKUP function is a vertical search function in Excel. It is the same as the LOOKUP function and The HLOOKUP function belongs to a type of function that is widely used in work. For example, it can be used to check data, quickly import data between multiple tables, 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.

Grammar rules

The syntax rules of this function are as follows:

VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)

This article comes from PHP Chinese websiteExcelTutorial column.

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