Insert Value
From XLCubedWiki
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:
- Select the XLCubed > Insert Formula > Value ribbon or menu option
- Choose a location for the new formulae
- Choose the connection to use from the dropdown
- Use the grid to select the hierarchies and member selections to retrieve the value for
- 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
