ARRAY.INDEX function

This article describes the formula syntax of the ARRAY.INDEX function.


Return rows and columns of array.


ARRAY.INDEX(array, rows, columns)

array is a array or handle to a array.
rows are an array of rows to return.
columns are an array of columns to return.

This works like INDEX for arrays except indices are cyclic. If rows or columns are missing then all rows or columns are returned.