Using TriLookup

1. Introduction to TriLookup

What is TriLookup?

TriLookup is an add-in for Microsoft® Excel for Windows versions 97, 2000, 2002 (XP), and 2003 and Excel for Macintosh versions 98, 2001 and X. 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.

All TriLookup functions can be accessed through Excel’s Function Wizard. They appear in the Lookup & Reference category of the Paste Function dialog (select Function... from the Inset worksheet menu, or click on the Paste Function button in the standard toolbar). See Using TriLookup Functions in Excel Worksheets for details.

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. See TriLookup Online Help and Examples for details.

TriLookup It is written entirely in Visual Basic for Applications (VBA).

1 2 3 4 5 6 Next