Coordinates
Key Coordinates of function Lookup in Tablerefers to the input coordinates in the form of a 2D-array with respect to which the table value must be looked up.
If the table has rank 1, a single row of values is expected here, which holds the coordinates that must be matched.
Furthermore, if the rank-1 table contains N coordinate columns, then the row of values here must consist of exactly N cells.
If the table has rank R, a range of values with R rows is expected here.
In the latter case, the i-th row must define Kᵢ values, where Kᵢ is the number of coordinate columns in the i-th subtable.
For example, let a table with rank 2, represented as a two-dimensional range, where the first (outer) dimension is spanned by 3 coordinates and the second (inner) dimension by 2 coordinates.
This table has its 3 leftmost columns dedicated in holding the coordinates along the first dimension and its 2 topmost rows dedicated for holding the coordinates along the second dimension.
Then a particular cell in the inner table can be returned by setting the input here as a range consisting with two rows and three columns.
The first row should contain 3 values that define the coordinates along the first dimension and thus define the corresponding row.
The second row should contain 2 values that define the coordinates along the second dimension and thus define the corresponding column.
The last cell of that second row must contain the special text [end], which marks the end of that row.