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.)
=IF(B1=LOOKUP(B1,x,x),LOOKUP(INDEX(x,MATCH
(LOOKUP(B1,x,x),x,0)),x,y),TREND(y,x,B1))
 
Search JabSto ::




Custom Search