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

=LOOKUP(B2,D2:D7,F2:F7)

Figure 8-4:
Using LOOKUP to look up a tax rate.