Microsoft Office Tutorials and References
In Depth Information
Table 8-2: Formulas for a Lookup Using Linear Interpolation
Performs a standard lookup on the x range and returns the
Returns TRUE if the looked-up value equals the value to be
Returns the row number of the x range that contains the
Returns the same row as the formula in B6 if an exact match
is found. Otherwise, it adds 1 to the result in B6.
Returns the x value that corresponds to the row in B6.
Returns the x value that corresponds to the row in B7.
Returns the y value that corresponds to the x value in B9.
Returns the y value that corresponds to the x value in B10.
Calculates an adjustment factor based on the difference
between the x values.
Calculates the estimated y value using the adjustment factor
Combining the lookup and trend functions
Another slightly different approach, which you may find preferable to performing lookup using linear interpola-
tion, uses the LOOKUP and TREND functions. One advantage is that it requires only one formula (see Figure