Returns the result of an MDX query as an array. This is a CSE/Array formula so must be entered into a range using Ctrl+Shift+Enter.
L3GridArrayLookup is the quickest way to return cube results into Excel, but limits your options for altering the query. Query Generators enable you to filter the report based on dimension slicers and cell values.
Syntax
XL3GridArrayLookup( Connection, Mdx, [MemberHandling] )
Parameters
Parameter | Description |
Connection | Connection number to use. |
Mdx | The query to run. Typically from a cell so that the query can be updated. |
MemberHandling | Optional, how to output members. Values are:
|
Example
This example shows the MDX statement in cell A1. Select the range you want to output the results to, and type.
Then press Ctrl+Shift+Enter.

Any cells outside the data area return #N/A.