Insert Value

XL3Lookup and XL3LookupRW formulae can be inserted directly into the spreadsheet using the XLCubed > Insert Formula > Value ribbon or menu option.

To insert a value lookup:

  1. Select the XLCubed > Insert Formula > Value ribbon or menu option
  2. Choose a location for the new formulae
  3. Choose the connection to use from the dropdown
  4. Use the grid to select the hierarchies and member selections to retrieve the value for
  5. Click OK and the formulae will be inserted

Additional Options

  • If you want to insert the writeable XL3LookupRW formulae instead of XL3Lookup, select the Insert XL3LookupRW checkbox

See Also