Display text from random cell

Hello there,
I am trying to see if it is possible to make this happen in excel.

For a study group, a teacher has suggested that we list out and cut up about 100 different topics, put them in a hat, and draw out three topics and then try to connect the ideas. That's a lot of writing... I was wondering If I enter all of the topic names sequentially into a column (say, B1-B100), could I write a function to display just the text of a random cell from the topic list as determined by the random number generator (in say, A1)?

My only thought is to use RANDBETWEEN(bottom, top) to have it define the row of the cell... But I don't know how to tweak excel beyond the basics much. If this function is the correct one to incorporate, how would I get it to spit out a new cell value to pick another topic "out of the hat"?

Any help would certainly be appreciated!

Not sure about that, does this help:

=INDEX(A1:E50;RANDBETWEEN(1;50);RANDBETWEEN(1;5))

You can define some area (in example A1:E50) and randomly return some value from that table. But area must be defined.
If you even take whole excel to be one area then you need to populate them all with some data (and that's lot of data )

Originally Posted by JBeaucaire

Sure, like this:

Wow- thanks a lot!

Originally Posted by JBeaucaire

Sure, like this:

This works fantastic!

Quick question...
Do you know how I would return a hyperlink that is associated with the text??

Fantastic thanks, I've adapted the spreadsheet and got just what i want! Brilliant