Defining a lookup object

To define a lookup object:

1. In Design Mode, click in an empty cell and click Lookup on the Objects toolbar.
   An empty lookup object is displayed.
2. Double-click the lookup object.
3. Specify this information:

   Name

   Optionally specify a name. By default, lookup objects are automatically named Lookup[n] where n is a sequential number. If you specify a name it can be easier to reference the lookup object in formulas and scripts.

   Value

   Specify a formula or cell reference to display the list that is displayed when you click the lookup. For example, specify a MEMBERGET formula.

   Formula for empty result

   By default (empty) is displayed if a lookup does not return any data. Optionally, specify a different text such as ="Please select....", for example.

   Tooltip

   By default, the value displayed by the lookup is used as a tooltip. Optionally, specify a different value, such as ="This is a list"

4. Select an icon to help to indicate the purpose of the lookup.
5. Specify the size and position of the lookup.
   See Size and Position tab.
6. On the Properties tab, specify whether to enable or disable the lookup object.
   By default, lookup objects are enabled.
7. Specify the availability of the lookup.
   See Availability tab.