So I'm trying to randomly select a cell from a colum of cards. I used the
function ADDRESS and RANDBETWEEN to get a random cell number
=ADDRESS((RANDBETWEEN(2,53)),1,4) to get a random cell from a list in colum
A. Now, I can't use that result (random cell number) for anything. It just
displays something like A22 when I use it in another cell. I need it to
display the contents of A22 to continue my project. Any ideas?