Returns a name or caption for a member in a given set.
Syntax
XL3SetLookup( Connection, SetExpression, [Position], [Format] )
Parameters
| Parameter | Description |
| Connection | Connection number to use. |
| SetExpression | The MDX expression to run. |
| Position | The number of the member in the set to return. 1-based, and defaults to the first member if omitted. |
| Format | The format to use for the returned member.
|
Examples
These examples are based on the Bicycle Sales cube.
The first region in Asia:
=XL3SetLookup( 1, "[Region].&[Asia].Children" )
The unique name of the second child of Mountain:
=XL3SetLookup(1, "[Product].&[Mountain].Children", 2, 3 )
