You can use =Rand() to generate a random number then use that to find a value
from the list...

If you have 10 values in the list and your list is in C1:C10 then use
=INDEX(C1:C10,ROUND(RAND()*10,0),1)

"JohnB" wrote:

Is there a function for randomly selecting a value from a list of values?