Arrays

Elements of arrays can be accessed directly using bracket notation. The value to use as an index starts at the number 1.

=ARRAY(1, 2, 3)[2]→2

=ARRAY(1, 2, 3)[1]→1

=ARRAY(1, 2, 3)[0]→#ERROR!