excel vlookup（Excel函数）.docVIP

excel vlookup（Excel函数） hide all In the first column value specifies the lookup table of the array, the other column values and thus return to form an array in the current row. The V VLOOKUP parameter in the vertical direction. When comparing the values in the data needed to find the left column, you can use VLOOKUP instead of HLOOKUP. grammar VLOOKUP (lookup_value, table_array, col_index_num, range_lookup) Lookup_value is in the form of an array of arrays (need for the establishment of a single formula can generate multiple results or operate on a set of parameters are arranged in rows and columns. The array area shares a common formula; an array constant is a set of constants used as parameters). In the first column to find the numerical. Lookup_value can reference for numerical or. If lookup_value is less than the minimum value of table_array in the first column, VLOOKUP #N/A returns an error. Table_array is two or more columns of data. The use of reference to regional or regional name. Table_array in the first column is the value of the lookup_value search by value. These values can be text, numeric or logical values. The text is case insensitive. Col_index_num is the column number, value to be returned in table_array. When Col_index_num is 1, table_array value returned in the first column; col_index_num is 2, table_array returns a value in the second column, and so on. If col_index_num: Less than 1, VLOOKUP returns an error #VALUE!. The number of columns is greater than table_array, VLOOKUP returns an error #REF!. Range_lookup is a logical value that specifies the hope VLOOKUP lookup exact matching value or approximate matching value: If TRUE or omitted, returns the exact matching value or approximate matching value. That is to say, if you can not find the exact matching value, the maximum value is returned less than lookup_value. Table_array in the first column value must be sorted in ascending order; otherwise, VLOOKUP may not be able to return the correct val