You can insert XL3PropertyLookup formulas directly into the spreadsheet using the Anaplan XL > Insert Formula > Member Property ribbon or menu option.

To insert a member property:

  1. Select the Anaplan XL > Insert Formula > Member Property ribbon or menu option.
  2. Choose a location for the new formula.
  3. Choose the connection to use from the dropdown.
  4. Select the hierarchy the property belongs to.
  5. Select the member to use.
  6. Choose a member property from the Property dropdown
  7. Select OK to insert the formula.