Defining a lookup object

  1. In Design mode, click in an empty cell and click Lookup on the Objects toolbar.
  2. Double-click the empty 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....".
    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.
  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.