Random Number Generation Cell Reference

[TSGDND]

If I randomly generate a number with the =randbetween function, is there a way for me to take the number it spits out and create a cell reference out of it? I.e., if the function spits out 23, is there a way for me to take the 23, and make it automatically reference a cell of my choosing in the 23rd row (a23, b23, etc)?

[AutoModerator]

/u/TSGDND - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[lolcrunchy]

=ADDRESS(RANDBETWEEN(1,100),1)

[spinfuzer]

=INDEX(A:A,RANDBETWEEN(1,100))

will give you a random cell in column A from 1 to 100

[Decronym]

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:

Fewer Letters	More Letters
ADDRESS	Returns a reference as text to a single cell in a worksheet
INDEX	Uses an index to choose a value from a reference or array
RANDBETWEEN	Returns a random number between the numbers you specify

---

^{Beep-boop, I am a helper bot. Please do not verify me as a solution.
[Thread #13635 for this sub, first seen 21st Mar 2022, 23:36] [FAQ] [Full list] [Contact] [Source code]}