The lookupmoreformula( function looks up additional data based on a previous lookup.


This function has two parameters:

formula – is the formula that will be used to extract data from the target database. The entire formula must be enclosed in quotes (see Quotes). This formula will be evaluated using the database specified by the previous lookup( or superlookup( function.

default – is the value you want this function to return if the previous lookup formula failed to find a match. The data type of the default value should match the result type of the Formula parameter. If the formula is numeric, the default should usually be zero. If the formula is text, the default should usually be "". Note: This parameter is optional. If it is omitted, the lookupmoreformula( function will return an error if the search fails.


This function is designed to retrieve additional information after a lookup( function. In this example, the procedure looks up a check from a Checkbook database. It first retrieves who the check was written to, then retrieves the age of the check (in days – today’s date minus the date of the check.)

Vendor = lookup("Checkbook","Number",ckNumber,"PayTo")
Age = lookupmoreformula({today()-Date})

The lookupmoreformula( function works with any lookup function, including lookup(, lookuplast(, lookupselected(, lookuplastselected(, and superlookup(. (It does not, however, work with the table( function.)

Error Messages

lookupmoreformula( function failed because previous lookup failed. – This function should only be used immediately after a lookup function.

See Also


10.0NewNew in this version.