Excel function CHOOSE

The CHOOSE function allows different data to be displayed depending on the number that is chosen (from 1 to a maximum of 29).

Select the CHOOSE function and enter the reference to the cell containing the number chosen in the "Index_num" box.

In this example, we want to display a different date depending on each person's choice:

choose function
autofill choose

The dates are displayed correctly after an AutoFill command: