Latest Info

TriLookup Users







TriLookup And TriLookupLite Add-Ins for Excel

TriLookup is an add-in for Microsoft® Excel for Windows version 97 or higher and Excel for Macintosh version 98 or higher (except version 2008). When installed, TriLookup adds eleven powerful lookup and interpolation worksheet functions to Excel, which offer greatly enhanced functionality compared to Excel's built-in lookup functions. You can use them to perform simple table lookup, as well as, interpolation and extrapolation from tables with one, two or three independent variables.

The newly released TriLookupLite and TriLookupLite Mac are freeware editions, which only allow linear interpolation. You can use them to evaluate TriLookup. If you only require linear interpolation, you can keep using TriLookupLite and TriLookupLite Mac for free indefinitely!

TriLookup has been used since 2003 worldwide by universities and hi-tech companies See a partial list here.

Animated T3LOOKUP ChartThe animated chart on the right shows a series of 3D surfaces plotted from the values returned by the T3LOOKUP function. Each individual surface in the series is calculated for a constant Z value.

TriLookup add-in package includes a comprehensive online help and a couple of example spreadsheets that demonstrate the capabilities and the proper usage of the added functions. You can access the online help and example files by selecting TriLookup Help from Excel’s Help menu.

TriLookup and TriLookupLite Editions

Starting in version 3.0, Trimill introduced TriLookupLite, as a Freeware edition of TriLookup. The differences between TriLookup and TriLookupLite are outlined in the table below:




Type of license




Required after a 30-day evaluation period

Not required

Implementation compatible with 64 bit Excel for Windows

Available by request to registered TriLookup users only

Available for download

Implementation compatible with Mac Excel (32 bit and 64 bit)

Available by request to registered TriLookup users only

Available for download

Limitations on the type of interpolation (parameters Interpolate, X_Interpolate, Y_Interpolate and Z_Interpolate)

No limitations
(valid values: -20 to 7)

Limited to: No interpolation (exact match, exact match or lower, exact match or higher, closest value) and Linear Interpolation
(valid values: 0 to 4)

Limitations on the maximum polynomial order (parameter Max_order in TVPOLYDATA and THPOLYDATA functions)

No limitations
(valid values: 1 to 20)

Limited to 6
(valid values: 1 to 6)

Apart from the differences outlined above, the eleven TriLookup worksheet functions work exactly the same way on both TriLookup and TriLookupLite.

You can have either TriLookup or TriLookupLite installed on your computer at one time. Installing TriLookup or TriLookupLite will overwrite any previous installation of TriLookup or TriLookupLite.

The evaluation version of TriLookup is fully functional and differs from the registered version only by displaying "TriLookup splash screen" every time you start Excel.

Implementations of TriLookup and TriLookupLite

TriLookup and TriLookupLite editions are available in three different implementations:

  • 32 Win, which works on 32 bit Excel versions 97 - 2016 for Windows (any version of Windows, both 32 bit and 64 bit);

  • 64 Win, which works on 64 bit Excel versions 2007 - 2016 for Windows (any version of 64 bit Windows);

  • Mac, which works on 32 bit and 64 bit Excel versions 98 or through 2016 for Macintosh (with the exception of Mac Excel version 2008, which doesn’t support VBA).

The eleven TriLookup worksheet functions work exactly the same way on both Windows and Macintosh, on all supported versions of Excel.

The differences between 32 Win, 64 Win and Mac implementations of TriLookup and TriLookupLite are shown in the table below:


32 Win

64 Win



Automatic, via Windows setup program

Automatic, via Windows setup program

Manual, unzip files and add through Excel Add-ins dialog

Online help file

Includes TriLookup.hlp

Includes TriLookup.hlp

Not included

TriLookup functions in the Paste Function dialog are listed in

custom TriLookup category

built in Lookup & Reference category

built in Lookup & Reference category

Help messages for function parameters in the Formula Palette dialog




You can also view or download TriLookup User's Guide in pdf format. In order to view this file you must have Adobe® Acrobat® Reader installed on your computer.

Copyright © Trimill Industrial Systems Inc.