We can enter an array in a cell as a formula such as ={"Right","Wrong"}.
The cell will only display the first value of the array. So far, so good.
However, when we attempt to access this array we are not having much
success.

For example, if the array is stored in cell A1, we place the formula
=INDEX(A1,1,2) in cell A2. We assumed that the the formula in A2 would
display the word "Wrong" which is the second element of the array as
specified in the INDEX() function. Instead, we get the #REF error.

Any thoughts on how we can use a formula to create an array result, store
the array in a cell, and then access the array from the cell and use it in a
formula that will accept an array argument?