LOOKUP$
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 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.
See also: