Returns a name or caption of a member at a given level.

XL3MemberLevelLookup( Connection, Position, Hierarchy, Level )

ParameterDescription
ConnectionConnection number to use.
PositionNumber of member to return.
HierarchyName of the hierarchy that the member applies to, for example, "Measures" or "[Customer].[Customer Geography]".
LevelLevel whose child should be returned.

These examples are based on the Bicycle Sales cube.

Returns Asia, the 3rd member on level Continent.

=XL3MemberLevelLookup( 1, 3, "Region", "Continent" )