Returns the value of a cell for a specified instance. Used to link different instances.

Syntax

=MM_INSTANCE(Cell, Param, [NanIfNotExists])

• Cell
  Cell which contains the value you want the function to return. Cell is not meant to be a range bigger than a cell.

• Param
  Index or name of the instance you want to access.

• NanIfNotExists (optional)
  Boolean value.
  If TRUE, the function returns NaN if the instance the function is trying to access does not exist.
  If FALSE, the function returns the initial value of the cell in other words, the value in Excel.

Remarks

• For a selected instance inside a table, calling the index of that same instance amount to not using the function at all. 

• You can access all values of a multidimensional cell for a specified instance even if the loop does not exist for the selected instance.

Example 1: Basic example

In this example, three instances were added beforehand. Suppose that the result of cell A2 is different for each instance. To access all results in one table without navigating in Mind through the instances, use MM_INSTANCE as shown below.

The table #Instance Results displays the result of cell A2 for the three instances.

Example 2: Example with dynamic loops

Let us continue with the previous example. 

In cell A2, the following formula is input:

=MM_LOOP("Loop for instance: " & MM_INSTINDEX(), MM_COLUMN(G2))

As a consequence, one loop is defined for each instance. Besides, they can have different size, using MM_COLUMN (G2 refers to the loop inputs we do not show). 

Without MM_INSTANCE, you can only access the loop corresponding to the instance you selected. 

With MM_INSTANCE, you can access all the loops in the table #Instance Results for any instance selected. Here, we have selected the first instance by default.

In the above table, 

• the value 58 refers to the value of cell A2 for Instance #1 and dimension 2 of Loop for instance: 1, 

• the value 337 refers to the value of cell A2 for Instance #2 and dimension 2 of Loop for instance: 2, 

• the value 85 refers to the value of cell A2 for Instance #3 and dimension 1 of Loop for instance: 3.