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
Figure 8-3: Using HLOOKUP to look up a tax rate.
The LOOKUP function
The LOOKUP function has the following syntax:
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.