GETARRAYITEM

This function returns an item from an array.

The arguments of the function are a reference to the array, and an index number that indicates which item of the array to return.

Syntax

=GETARRAYITEM(array, index)

Example

This example references an array in cell C8 and returns the first item in the array:

=GETARRAYITEM(C8, 1)