Office software is closely linked to the PDF,the PDF is also must have to control!
Set home Page Add to Favorites
|
The array form of LOOKUP function in the array or the first column of the first line to find the specified value, and then return to the last line of the array, or a final position in the same values. Under normal circumstances, it is best to use or HLOOKUP function VLOOKUP function to replace the array form of LOOKUP function. This form of the LOOKUP function is mainly used with other compatible spreadsheet. On the array form of LOOKUP use shall not repeat them here, of interest to refer to the help of Excel. 3, HLOOKUP and VLOOKUP HLOOKUP for numerical arrays in the table or the first line to find the specified value, and thus return to the table or the array specified in the current line out numerical Department. VLOOKUP for numerical arrays in the table or to find out the first specified value, and thus return to the table or the array specified in the current row column values. When comparing the value of data tables is located in the first line, and to find the following line to the data set, use the function HLOOKUP. When comparing the value of data is located to the left to find one, use the function VLOOKUP. Grammatical form: HLOOKUP (lookup_value, table_array, row_index_num, range_lookup) VLOOKUP (lookup_value, table_array, col_index_num, range_lookup) Which, Lookup_value that are looking for value, it must be in the custom region to find the most left column. Lookup_value for value, quote or text string. Find Table_array the region, the region used to search for data, find the value of the above must be located in the left column in the region. Can use the name of the region or regions of reference. Table_array in Row_index_num for matching values to be returned to the line number. Row_index_num to 1, to return to the first line of table_array Numerical, row_index_num for 2, return to the second line table_array value, and so on. No. Col_index_num relative out. The left column is 1, the right one as 2, and so on. Range_lookup is a logic value, find the specified function is HLOOKUP exact match or approximate match. |
