Using row number to look up cell value

[aubreyms]

I have a couple hundred random cell values to find out of tens of thousands of rows. Each cell value will be in column A.

In the past, I have just used =randbetween(1,60000) and found the random row numbers, then sorted through to get the corresponding cell values I need. I know enough know, that I can add =A to each random number and come up with the list.

Is there an easier way to do this?

 

[T. Valko]

I have a couple hundred random cell values to find out of tens of thousands of rows. Each cell value will be in column A.

In the past, I have just used =randbetween(1,60000) and found the random row numbers, then sorted through to get the corresponding cell values I need. I know enough know, that I can add =A to each random number and come up with the list.

Is there an easier way to do this?

Maybe something like this...

=INDEX(A:A,RANDBETWEEN(1,60000))

 

[aubreyms]

That works perfectly! Thank you!

 

[T. Valko]

That works perfectly! Thank you!

You're welcome. Thanks for the feedback!