Microsoft Office Tutorials and References
In Depth Information
• result_vector: The single-column or single-row range that contains the values to be returned. It must be the
same size as the lookup_vector.
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 ) .
Values in the lookup_vector must be in ascending order. If lookup_value is smaller than
the smallest value in lookup_vector, LOOKUP returns #N/A.
The Help system also lists an “array” syntax for the LOOKUP function. This alternative
syntax is included for compatibility with other spreadsheet products. In general, you
can use the VLOOKUP or HLOOKUP functions rather than the array syntax.
Figure 8-4 shows the tax table again. This time, the formula in cell B3 uses the LOOKUP function to return the
corresponding tax rate. The formula in B3 is
Figure 8-4: Using LOOKUP to look up a tax rate.