Getting the text from a random cell / row

Hello!

I've made myself an archive listing all of my cd's. One column for artist, one for album, one for production-year, etc..

I want excel to pick a random artist and album-name, and display it. How can I do this? It shouldn't be impossible I'm using regular excel 2003, with no extras.

I started off with =INT(rand()*(720-9)+9) (I've tried to translate it to english) This picks a random row-number for me. But what next? And I was thinking maybe I could define a variable x=("randomnumber"), and write something like =INDIRECT("Ax"), but as you probably know, it doesn't work that way I can't find a way to display the text from a cell with this number!

I'm to be considered as an excel-amateur, so you should probably keep that in mind

(I hope I'm posting in the right place, I wasn't quite sure)

Thanks guys!

If you use INDEX then INT can be discarded because INDEX will truncate the index number anyway.

If you have alist of CDs starting at A9 this will allow you to select one at random and also add CDs to the list (up to row 1000) without altering the formula

=INDEX(A9:A1000,COUNTA(A9:A1000)*RAND()+1)