Parameters of vlookup function and explanation of their meanings

We must have used the vlookup function when using excel. So there are several such functions, and how each function is used. As far as the editor knows, there are four vlookup functions, namely Lookup_value, Table_array, col_index_num, and Range_lookup. So let me tell you their specific usage~

The vlookup function has several parameters and the meaning of each parameter

The parameters of the vlookup function include Lookup_value, Table_array, col_index_num, and Range_lookup. There are 4 in total.

1. Lookup_value is the value that needs to be searched 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.

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

3. col_index_num is the data column number used to search for data in table_array.

4. Range_lookup is a logical value, indicating whether the function VLOOKUP is an exact match or an approximate match when searching.

If FALSE or 0, an exact match is returned, or an error value #N/A is returned if not found.

VLOOKUP function syntax

1. There are four parameters in brackets, which are required.

The last parameter range_lookup is a logical value. We often enter a 0 word, or False. In fact, we can also enter a 1 word, or true.

The former means a complete search, and if it cannot find it, it will return an error value #N/A; the latter first searches for the exact same value, and

if it cannot find it, it will then search for a very close value. If it can't be found yet, it has to return the error value #N/A.

2. Lookup_value is a very important parameter. It can be a numerical value, a text string, or a reference address. What we often use is the reference address.

The cell format category of the reference address must be consistent with the cell format category of the search. Otherwise, sometimes you will clearly see that there is data, but you will not be able to capture it.

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