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))

[TABLE="width: 500"]
<tbody>[TR]
[TD]Row[/TD]
[TD]Column[/TD]
[TD]Result[/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]0[/TD]
[TD][TABLE="width: 98"]
<tbody>[TR]
[TD="width: 98"]test1[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]1[/TD]
[TD][TABLE="width: 98"]
<tbody>[TR]
[TD="width: 98"]test1[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]2[/TD]
[TD][TABLE="width: 98"]
<tbody>[TR]
[TD="width: 98, align: center"]#REF![/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]0[/TD]
[TD][TABLE="width: 98"]
<tbody>[TR]
[TD="width: 98"]test1[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1[/TD]
[TD][TABLE="width: 98"]
<tbody>[TR]
[TD="width: 98"]test1[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]2[/TD]
[TD][TABLE="width: 98"]
<tbody>[TR]
[TD="width: 98, align: center"]#REF![/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]0[/TD]
[TD][TABLE="width: 98"]
<tbody>[TR]
[TD="width: 98, align: center"]#REF![/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]1[/TD]
[TD][TABLE="width: 98"]
<tbody>[TR]
[TD="width: 98, align: center"]#REF![/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]2[/TD]
[TD][TABLE="width: 98"]
<tbody>[TR]
[TD="width: 98, align: center"]#REF![/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]0[/TD]
[TD][TABLE="width: 98"]
<tbody>[TR]
[TD="width: 98, align: center"]#REF![/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]1[/TD]
[TD][TABLE="width: 98"]
<tbody>[TR]
[TD="width: 98, align: center"]#REF![/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]2[/TD]
[TD][TABLE="width: 98"]
<tbody>[TR]
[TD="width: 98, align: center"]#REF![/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

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.