How to use the INDIRECT function of Excel?
The INDIRECT function provides you to create dynamique references by using the cells' contain as part of your references.
Random
Extract sample randomly in Excel
How to extract a sample of data random data? A combination of a random number and the function INDIRECT will return the result expected.