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)