Looks for a value in the leftmost column of a table, and then returns a value in the same row from a column you specify. By default, the table must be sorted in an ascending order.

语义 Syntax VLOOKUP(lookup_value,table_array,col_index_num,range_lookup) ▪ Lookup_value: is the value to be found in the first column of the table, and can be a value, a reference, or a text string. 要在表格t的第一列寻找的值，可以是值、引用或文本串。

▪ Table_array: is a table of text, numbers, or logical values, in which data is retrieved. Table_array can be a reference to a range or a range name. 用于数据检索的表格 (TABLE_NAME!)COLUMN1:COLUMNn

▪ Col_index_num: is the column number in table_array from which the matching value should be returned. The first column of values in the table is column 1. 匹配后想获取的列的值，取值1～n，第一列索引为1

▪ Range_lookup: is a logical value: to find the closest match in the first column (sorted in ascending order) = TRUE or omitted; find an exact match = FALSE. 模糊匹配 or 精准匹配