Microsoft Office Tutorials and References
In Depth Information
The HLOOKUP function's arguments are as follows:
lookup_value: The value that you want to look up in the first row of the lookup table.
table_array: The range that contains the lookup table.
row_index_num: The row number within the table from which the matching value is returned.
range_lookup: (Optional) If TRUE or omitted, an approximate match is returned. (If an exact match is not
found, the next largest value less than lookup_value is used.) If FALSE, VLOOKUP searches for an exact
match. If VLOOKUP cannot find an exact match, the function returns #N/A.
If the lookup_value argument is text (and the fourth argument is FALSE), you can use
the wildcard characters * and ?. An asterisk matches any number of characters, and a
question mark matches a single character.
Figure 8-3 shows the tax rate example with a horizontal lookup table (in the range E1:J3). The formula in cell
B3 is
=HLOOKUP(B2,E1:J3,3)
Figure 8-3: Using HLOOKUP to look up a tax rate.
The LOOKUP function
The LOOKUP function has the following syntax:
LOOKUP(lookup_value,lookup_vector,result_vector)
The function's arguments are as follows:
lookup_value: The value that you want to look up in the lookup_vector.
lookup_vector: A single-column or single-row range that contains the values to be looked up. These values
must be in ascending order.
Search JabSto ::




Custom Search