Windows and Macintosh Versions of TriLookup

Starting in version 2.2, in addition to Windows, TriLookup is also supported on Excel for Macintosh versions 98, 2001, and X.

The eleven TriLookup worksheet functions work exactly the same way on both Windows and Macintosh, and on all supported versions of Excel (Excel 97 or higher on Windows and Excel 98 or higher on Macintosh).

However, there are a some differences between the Windows and Macintosh implementations of TriLookup in the following areas:

· The automated setup program for installing and uninstalling TriLookup is provided only for Windows. Macintosh version has to be installed manually.

· Windows version includes a complete online help file TriLookup.hlp that can be accessed from Excel’s Help menu, from the Paste Function dialog and from the TriLookup example workbooks. Although Macintosh version contains the same help file, it can only be displayed by Excel 98. Since Excel versions 2001 and X cannot display the “.hlp” files, the Macintosh version of TriLookup also includes a collection of help files in HTML format that can be viewed using any Web browser. The HTML help files can be accessed from Excel’s Help menu and from the TriLookup example workbooks, but not from the Paste Function dialog.

Note that the HTML help files do not contain the examples for TriLookup functions and parameters. If you wish to view these examples on the Macintosh with Excel versions 2001 and X you must download the pdf version of TriLookup User's Guide.

· In Windows version the TriLookup functions appear in the TriLookup category of the Paste Function dialog. In Macintosh version the TriLookup functions appear in the built in Lookup & Reference category of the Paste Function dialog.

· Only Windows version of TriLookup displays short help messages for each of the function parameters in the Formula Palette dialog.

· A potential problem with broken references that occurs after moving workbooks with TriLookup functions to another computer generally affects only Macintosh version. See TriLookup User's Guide for details.