Replaces loop indexes by labels in Mind tables. To be used with the MM_LOOP function. 

Syntax

=MM_LOOPLABELS("LoopName", Labels, [Index])

• "LoopName"
  String. Name of the loop for which you want to add labels.

• Labels
  Range corresponding to the labels you want to add.

• Index (optional)
  Index of the loop label you want to display in the cell.

Remarks

• Labels must be of the same size than the specified loop. 

• In Mind, the function returns by default the first label if the parameter Index is not input. Otherwise, it returns the label corresponding to Index.

Example 1: Simple case

Formula 1: =MM_LOOP("Rate",A3:A5) creates a 3-dimensional loop named "Rate".
Formula 2: =MM_LOOPLABELS("Rate",C3:C5) replaces the loop indexes (1,2,3) by the loop labels (Product A, Product B, Product C).

This is what you get in Mind. Instead of navigating through the indexes of the loop "Rate", you can select the desired label.

Example 2: Variable loop names

Labels does not need to be a constant. It can be the results of some formulas.

In this example, the name of the loop dimension depends on the loop dimension value. If you change one assumption (under the column "Loop Value"), the corresponding label will also change.

Here is what you get for the above assumptions. You can change the values of the loop "Rate" and the corresponding labels will change after each run.