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.