Returns a name or caption for a member in a given set.


XL3SetLookup( Connection, SetExpression, [Position], [Format] )


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.
0 Member caption (default)
3 Member unique name

Examples (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 )

See Also