Contents - Index
The LOOKUP$ function operates just like the LOOKUP function except that it returns a string rather than a numerical value. As in the LOOKUP function the, LOOKUP$ function normally requires three arguments. The first is a string constant or string variable that provides the name of the Lookup table in the Lookup Table Window or the name of Lookup file stored on disk. The next argument is a numerical value or expression that provides the row in the table. This row value should be an integer. Interpolation between rows is not allowed, as it is in the LOOKUP function. The final parameter indicates the column. The column can be indicated by a numerical value or expression which provides the column number or by the name of the column provided in a string constant or string variable.
Note. In order to accept string information, the format style of the column in the Lookup table must be set to STRING. To change the format style, click in the column header and make the change in the Format Table dialog window.
For backward compatibility, the Lookup$ function will accept two (rather than three) arguments where the first argument specifying the Lookup table name or file name is not provided. In this case, EES will assume that the Lookup$ function is to be applied to the first table in the Lookup Table window.