Excel 2010 Bible

Part II: Working with Formulas and Functions

314

The syntax for the HLOOKUP function is

HLOOKUP(lookup_value,table_array,row_index_num,range_lookup)

The HLOOKUP function’s arguments are as follows

l lookup_value: The value to be looked up in the first row of the lookup table.

l (^) table_array: The range that contains the lookup table.
l row_index_num: The row number within the table from which the matching value is
returned.
l 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 returned.) If
FALSE, VLOOKUP will search for an exact match. If VLOOKUP can’t find an exact match,
the function returns #N/A.
Tip
If the lookup_value argument is text and the range_lookup argument is False, the lookup_value can include
wildcard characters * and?.
Figure 14.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 14.3
Using HLOOKUP to look up a tax rate.

The LOOKUP function ............................................................................................

The LOOKUP function looks in a one-row or one-column range (lookup_vector) for a value (lookup_

value) and returns a value from the same position in a second one-row or one-column range

(result_vector).

The LOOKUP function has the following syntax:

LOOKUP(lookup_value,lookup_vector,result_vector)