Excel Function: CHOOSE

The Excel function CHOOSE displays a value based on the chosen number (from 1 to 29 at most).


=CHOOSE(number, value_if_1, value_if_2, etc)

Usage example

The goal here is to complete the "Activity" column based on the participant's choice:

excel function choose

Select the CHOOSE function and enter:

choose function

Before dragging the formula down, add the $ symbol before the row number of the activities to lock it when you copy down:


You can now drag the formula down:

If needed, you can download the Excel file used here: choose.xlsx