Jump to: navigation, search
  • Main page
  • Recent changes
  • Random page
  • 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