Microsoft Office Tutorials and References
In Depth Information
Specialized Lookup Formulas
Figure 8-18: This worksheet uses a formula that uses the LOOKUP function and the TREND function.
The formula in cell B2 follows. This formula uses an IF function to make a decision. If an exact
match is found in the x range, the formula returns the corresponding y value (using the LOOKUP
function). If an exact match is not found, the formula uses the TREND function to return the
calculated “best-fit” y value. (It does not perform a linear interpolation.)
Search JabSto ::

Custom Search