ARRAY.INDEX function

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

Description

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.

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.