Barb Reinhardt wrote...
Tools - Add-ins ... Select Analysis tool pack.

Enter this in the cell for your random values.

=INDIRECT("A"&RANDBETWEEN(2,300))
....

Unnecessary. Could be achieved using

=INDEX($A$2:$A$300,2+INT(299*RAND()))