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.
In this example, we want to display a different date depending on each person's choice:
The dates are displayed correctly after an AutoFill command: