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)
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.