excel vlookup函数的使用注意事项

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.

• 在表格t的最左列找到一个值v，然后返回你特定列的与v同一行的值。
  【规定了最左列作为合并列的索引列。因为这个问题产生#N/A困惑了好久，还是没有仔细看文档】
• 默认表格必须按升序排列。
  【这个排序要求暂时没有体会到】

语义
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 精准匹配