Contents - Index
The LOOKUPCELLEMPTY requires the same inputs as the LOOKUP function. These are 1) the name of the Lookup table or Lookup file, 2) the row and 3) the column. As with the LOOKUP function, the column can be designated with an integer or EES variable or expression that evaluates to an integer for the column number, or by specifying the name of the a string constant or string variable that provides the name of the column.
The function returns either a 0 (if the specified cell is empty) or 1 if it contains a value. The function can be used with logic statement such as IF THEN ELSE and REPEAT - UNTIL in internal Functions and Procedures to ensure that a cell in the lookup table or file contains a value.