- Picture and text skills
- Case
Finds the specified value in the first column of the table or numeric array, and returns the value in the specified column in the current row of the table or array.
By default, the table is in ascending order.
Grammar
VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup])
■Lookup_value is the value that needs to be looked up 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 search for data in table_array. When col_index_num is 1, return the number of the first column of table_array
Value, when col_index_num is 2, return the value of the second column of table_array, 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 column of table_array
Number, function VLOOKUP returns error value #REF!.
■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, returns fine
Exact match, if not found, return error value #N/A. If range_lookup is TRUE or 1, function VLOOKUP will look for approximate matching values,
That is, if an exact matching value is not found, the largest value less than lookup_value is returned. If range_lookup is omitted, it defaults to 1.
Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/cha-zhao-he-yin-yong-han-shu-VLOOKUP-han-shu-cha-xun-zhi-ding-tiao-jian-de-jie-guo.html
评论列表(196条)
测试