Excel Choose Function

The CHOOSE function in Excel allows you to 'Choose' a "value' depending on a specific input.

1.Randomly CHOOSE names (where value is "text" (in quotes))
2.The CHOOSE function can help show which fiscal quarter a month is in, or show the total sales for a selected store number

Try a formula construction like (with lookup value in cell B1):
=CHOOSE(B1,A1,A2,A3,A4,A5,A6,A7)

Watch this video to see how to use the Excel CHOOSE function, and select items in a list.