Automatically direct values of randomly chosen cells

[Koen Straatman]

Hi,

I have created a row of cells that gives a random number between two values.

Beneath that row, i would like to create arow which directs the values of the collumn A in the rownumber which is randomly chosen in the row above it. 

For instance:

Row 100: 25, 14, 42. etc. 
Row 101: [A25], [A14], [A42] etc.

Is there an option to automatically do this?

[#2]

Hi @Koen Straatman

Did you have the value of 25, 14, 42. etc in one cell or separated cells.

Or else show me an example.

[#3]

Hi Logaraj Sekar,

These values are placed in one row. It is a row of 450 seperate random values in 450 cells located next to each other.