What is the use of the common excel function 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, quickly import data between multiple tables, etc. function functionality.

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 is required in The value to be searched for in the first column of the data table. 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 find 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.

Originally from the EXCEL basic tutorial column: http://www.php.cn/topic/excel/

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