Contents - Index

LOOKCOLNUMBER

LOOKUPCOLNUMBER('TableName', 'ColumnName') returns the column number of a specified column name in a Lookup table.  'TableName' is the name of a Lookup table or a Lookup file.  It may be a string constant or string variable.  'ColumnName' is the name of the column and must be string constant or string variable.  If the column is not found, the function will return -9999.

Example:

V=LookupColName('Lookup 1','Column1')

See also:  LOOKUPCOLNAME$