You can use the following formula to select a random value from a list in Google Sheets:
=INDEX(A2:A16, RANDBETWEEN(1, COUNTA(A2:A16)))
This particular formula selects a random value from the range A2:A16.
The following example shows how to use this formula in practice.
Example: Select Random Value from List in Google Sheets
Suppose we have the following list of values in Google Sheets:
We can type the following formula into cell C2 to select a random value from the range A2:A16:
=INDEX(A2:A16, RANDBETWEEN(1, COUNTA(A2:A16)))
The following screenshot shows how to use this syntax in practice:
We can see that the formula randomly selected 26 from the list of values in column A.
If you click on cell C2 and click Ctrl+C, then click Ctrl+V to paste the same formula back into cell C2, a new value will be randomly selected from the list:
We can see that the formula randomly selected 33 from the list of values this time.
Note: You can find the complete documentation for the RANDBETWEEN function in Google Sheets here.
Additional Resources
The following tutorials explain how to perform other common tasks in Google Sheets:
How to Randomize a List in Google Sheets
How to Select a Random Sample in Google Sheets
