|
LINTERP2D function
LINTERP2D provides efficient 2-dimensional linear interpolation in a table of values.
The LINTERP2D function is similar to VLOOKUP, except that it calculates 2-dimensional row and column linear interpolations between the values in a lookup table if an exact match cannot be found.
A single Lookup_1stCol and Lookup_1stRow will return a single interpolated value.
Multiple pairs of Lookup_1stCol and Lookup_1stRow values will return a vector of values.
LINTERP2D is a multi-threaded, non-volatile array function.
LINTERP2D Syntax
LINTERP2D (Lookup_1stCol, Table_Values, Lookup_1stRow)
Lookup_1stCol
the value(s) to lookup in the first column of Table_Values.
Table_Values
a rectangular set of values to be used for the interpolation. The first column must contain the values to be looked up using Lookup_1stCol. The first row must contain the values to be looked up using Lookup_1stRow. The other rows and columns contain the values to be interpolated between.
Lookup_1stRow
the value(s) to lookup in the first row of Table_Values.
Remarks
Table_Values must be a rectangular set of values (range, array or expression) sorted ascending on the first column and on the first row. It should not contain empty values in the first column or row.
Table_Values should not contain column or row labels.
When using more than one pair of Lookup_1stCol and Lookup_1stRow values LINTERP2D should be entered as an array formula using Control/Shift/Enter. Oe as a dynamic array formula
LINTERP2D returns #NA if Lookup_1stCol or Lookup_1stRow are outside the boundary values of Table_Values.
LINTERP2D returns #VALUE if any of the used input values are not numeric.
|
