TriLookup Add-In for Excel

Latest News!

As of March 27, 2020, TriLookup is free for all future and current users, without any restrictions as to the type of use or the number of users. To register and activate your free copy of TriLookup please use the credentials below.

Registered User Name: TRILOOKUP
Registration Code: L16F3736BQ72
Number of Licenses: Unlimited

We have also made the full 64 version of TriLookup available for free download. The 64 version doesn't require registration.

The source code is still protected, but we are planning to eventually change TriLookup to Open Source. If you would like to get an earlier access to the TriLookup source code, please contact us at info@trimill.com

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 Chart The 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:

Description	TriLolokup	TriLookupLite
Type of license	Shareware	Freeware
Registration	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.

Note:
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:

Implementation	32 Win	64 Win	Mac
Installing	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	Yes	No	No

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.