I am using the RAND function to generate a row number from which I want to
extract the contents of the cell at a specific column at that row. I have
used the ADDRESS function to create a text string that is the cell reference.
I am trying to use the CELL function with the "contents" info type but I
can't figure out how to use the cell reference I have created to direct the
function to the cell to get the contents.

=ROUND((RAND()*(COUNTIF(A:A, "<"))-1),0) (places an integer number in cell
F2)
=ADDRESS(F2,1) (Returns the text string for the Cell in column A, row
defined as number generated and placed in F2)

=CELL("contents", ???) When I try to use the reference to the cell that the
text string is in from the ADDRESS function, I get the text string back.
When I nest Cell functions, I get an error.