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 "Value1", enter the value to display when "Index_num" is equal to 1.
  • In "Value2", enter the value to display when "Index_num" is equal to 2.
  • Etc.

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

choose function - choose
autofill choose - choose

The dates are displayed correctly after an AutoFill command :

choose - choose