=INDIRECT("B"&INT(RAND()*371)+1)


On Oct 31, 10:46 am, JE McGimpsey wrote:
That just produces a text value, not the contents of the desired cell...

In article ,
Teethless mama wrote:



="B"&RANDBETWEEN(1,371)

Required ATP add-ins

"Frankd410" wrote:

I have a random number from 1- 371
That points to a cell for example
Random number is 233
I want the value of the contents in cell B233

How can I do this- Hide quoted text -

- Show quoted text -