Is it possible to Index a single cell array?

[JonDalton]

I was trying to randomly select items from an array, I don't think the below is possible so I'm going to break it out into cells.

I have an array in A1, everything below is submitted with ctrl shift enter just in case.

A1={"test1","test2","test3"}

I want to be able to:
=INDEX(A1,RANDBETWEEN(1,3))

Results from =INDEX,A1,RANDBETWEEN(Row,Column))

Row	Column	Result
0	0	test1 <tbody> </tbody>
0	1	test1 <tbody> </tbody>
0	2	#REF! <tbody> </tbody>
1	0	test1 <tbody> </tbody>
1	1	test1 <tbody> </tbody>
1	2	#REF! <tbody> </tbody>
2	0	#REF! <tbody> </tbody>
2	1	#REF! <tbody> </tbody>
2	2	#REF! <tbody> </tbody>
3	0	#REF! <tbody> </tbody>
3	1	#REF! <tbody> </tbody>
3	2	#REF! <tbody> </tbody>

<tbody>
</tbody>

Is this possible with a different function?

 

[RoryA]

No, you can't do that. You could put the array into a defined name instead.

 

[JonDalton]

No, you can't do that. You could put the array into a defined name instead.

Awesome, thank you.. This also solves the next problem I had of dynamically generating the array.

 

[RoryA]

I suspected as much.