Contents - Index


Lookup and Lookup$ (Macro Commands)

 

LOOKUP['Table Name', Row, Column]=Value

Set the value of the cell at the specified row and column of the specified Lookup table to the given value.  Column must either be an integer, referring to the column number or a string constant or string variable that provides the name of the column.   Use the AlterValues macro command to set the values of multiple rows.

 

LOOKUP$['Table Name', Row, Column]=F$

Set the value of the cell at the specified row and column of the specified Lookup table to the given string.  F$ can be a string constant or string variable (ending with a $ sign as shown)  Column must either be an integer, referring to the column number or a string constant or string variable that provides the name of the column.  Note that the column in the Lookup table must be designated for string variables.

 

MacroCommands