Microsoft Office Tutorials and References
In Depth Information
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