Using TriLookup

6. Index of TriLookup Functions

Below is a list and a brief description of all TriLookup worksheet functions. See also TriLookup examples.

TVLOOKUP
Searches a 2D multi column table for the lookup value in the lookup column and returns a value from the same row of the return column. It can use interpolation and can process missing or invalid values.

TVLKP
Simplified version of TVLOOKUP. Searches a 2D multi column table for the lookup value in the lookup column and returns a value from the same row of the return column. It can use interpolation.

THLOOKUP
Searches a 2D multi row table for the lookup value in the lookup row and returns a value from the same column of the return row. It can use interpolation and can process missing or invalid values.

THLKP
Simplified version of THLOOKUP. Searches a 2D multi row table for the lookup value in the lookup row and returns a value from the same column of the return row. It can use various types of interpolation.

T2LOOKUP
Searches a 2D (X-Y) table for X values in topmost row and Y values in leftmost column, and returns a value from the intersecting row and column. It can use interpolation and can process missing or invalid values.

T2LKP
Simplified version of T2LOOKUP. Searches a 2D (X-Y) table for X values in topmost row and Y values in leftmost column, and returns a value from the intersecting row and column. It can use interpolation.

T3LOOKUP
Searches a 3D (X-Y-Z) table for X, Y and Z values. Returns a value V(x,y,z) from the intersecting row, column and table. It can use interpolation and can process missing or invalid values.

T3LKP
Simplified version of T3LOOKUP. Searches a 3D (X-Y-Z) table for X, Y and Z values. Returns a value V(x,y,z) from the intersecting row, column and table. It can use interpolation.

TVPOLYDATA
Calculates polynomial curve coefficients up to a specified order (using the least squares method) for the X-Y data points given in a multi-column table. It also determines the best fit curve.

THPOLYDATA
Calculates polynomial curve coefficients up to a specified order (using the least squares method) for the X-Y data points given in a multi-row table. It also determines the best fit curve.

TPOLY
Returns the Y value of a polynomial curve for given a lookup value (X), polynomial order and an array of polynomial curve coefficients. It can optionally return the value of a derivative.

Previous 1 2 3 4 5 6