| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "Insert Value"
(Created page with '{{Code|XL3Lookup}} and {{Code|XL3LookupRW}} formulae can be inserted directly into the spreadsheet using the {{Menu|XLCubed|Insert Formula|Value}} ribbon or menu option. …') |
(Added Additional Options title) |
||
| Line 8: | Line 8: | ||
# Click '''OK''' and the formulae will be inserted | # Click '''OK''' and the formulae will be inserted | ||
| + | ==Additional Options== | ||
* If you want to insert the writeable {{Code|XL3LookupRW}} formulae instead of {{Code|XL3Lookup}}, select the '''Insert XL3LookupRW''' checkbox | * If you want to insert the writeable {{Code|XL3LookupRW}} formulae instead of {{Code|XL3Lookup}}, select the '''Insert XL3LookupRW''' checkbox | ||
Latest revision as of 15:54, 13 October 2010
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
