The Excel Choose function– Choosing random values from a list

The Choose function will select a value from a list of possibilities based on the relative position specified.

=CHOOSE(relative position, Option 1, Option2, Option 3, Option4)

choose function

In the above example we are selecting a value in the “Original List” based on the relative position in the list as prescribed in the cells in column B.