Description

Retrieves values from a specific iteration in another workbook on which iterations were defined. To learn more about iterations, check the general article on iterations.

Syntax

=MM_READITERATION(Cell, Iteration)

• Cell
  Cell to read. The cell is from another workbook on which iterations are defined.
• Iteration
  The index of the iteration to output.

Remarks

• Do not use MM_READITERATION if Cell belongs to the same workbook as the function MM_READITERATION you are trying to use. Inside the same workbook, the iterations work like a regular loop, meaning cells with the dependency will automatically inherit the iteration loop.

Example

The formula =MM_ITERATION([Workbook]Sheet1!A1, 2) returns the value of the cell for the second iteration.