Calling the contents of a random cell
=Indirect("L"&int(rand()*92))
"suitcase" wrote:
Hi. I have a spread sheet with 90 values in cells L1 through L91.
I am using =int(rand()*91+1) to generate random integers from 1 to 91. I
then want cell C3 to display the contents of L** depending on which random
number was called (so if it give me 10, C3 should display the contents of
L10).
Could anyone tell me how is best to do this. I can't use nested IF
statements as I have too much information in the list.
Thanks.
|