Fill cell with random cell?

[wrocman]

No answer to my last question so i'll try another way:

How can I fill a cell with text from another cell e.g. Kx where x is a random number between 1-10?

Thanks

[sweep]

Hi,

If you want an actual random number, try this:

="K"&ROUND(RAND()*10,0)

if you want to reference another cell, this,

="K"&A1

[sweep]

Having now read your post agin - I think you want to select a cell at random between K1 and K10, and return the contents. If this case,

=INDIRECT("K"&ROUND(RAND()*10,0))

[wrocman]

Thanks, worked a treat!