{oapdf_gg}
four, HLOOKUP, LOOKUP, MATCH, VLOOKUP 1, LOOKUP function with MATCH function LOOKUP function can return vector (single region or a separate region) or an array of values. This series of functions or values in the table for the first line array to find the specified value, and thus return to the table or the array specified in the current line out numerical Department. When comparing the value of data tables is located in the first line, and to find the following line of the given data, the use of function HLOOKUP. When comparing the value of data is located to the left to find a used function VLOOKUP. If you need to find out the location of matching elements to match the elements rather than their own, they should be used rather than the function MATCH function LOOKUP. MATCH function to return to the way the specified value match with the specified array of elements in the corresponding position. From the above analysis we can see that the function of search function, one based on search criteria, to return to search data in the region a data value; second is based on search criteria, to return to the search area has been the location of a data value. The use of these two functions can not only query the data, but also to solve such as "classification" and the practical problems. 2, LOOKUP return vector for the (single region or a separate region) or an array of values. LOOKUP function has two syntax forms: vector and array. (1) vector form The vector form of LOOKUP function in the single region or a separate region (Vector) to find values, and then return the second one-way or in a separate region in the same location of the regional values. The form of the basic grammar LOOKUP (lookup_value, lookup_vector, result_vector) LOOKUP function Lookup_value for vectors in the first to find values. Lookup_value can figure, text, logical values, or contains the name or reference value. Lookup_vector contains only a line or area. Numerical Lookup_vector for text, numbers, or logical values. Lookup_vector should be noted that the value must be sorted by ascending :...,- 2, -1,0,1,2 ,..., AZ, FALSE, TRUE; Otherwise, the LOOKUP function can not return the correct results. The text is not case-sensitive. Result_vector contains a line or a region, its size must be the same lookup_vector. If LOOKUP can not find function lookup_value, while lookup_vector Find lookup_value in less than or equal to the maximum value. If lookup_value less than the minimum value in lookup_vector, LOOKUP function to return the error value # N / A. See Figure 3 Example |