How to Use the CHOOSE Formula in Excel

The CHOOSE formula is used to index a number and return the desired comment based on the number. This formula allows you to apply a characteristic associated with a certain number.

Formula Explanation:

• Index number: This specifies which value argument is selected. It must be a number between 1 and 254, or a formula or a reference to a number between 1 and 254.
• Value 1, Value 2…: Value 1, value 2, etc can be cell references, defined names, formulas, functions, or text arguments from which CHOOSE selects. They must be in sequential order. For instance, if you choose a range to index and perform the lookup to a value range, the first value will be returned for the first number indexed.

Example:

In this example, we will insert a comment into the right side of the below table based on the GPA scores of students. The value options are poor (1), average (2), good (3), and outstanding (4).

Solution:

In the above table:

• Index_number is each GPA for which we want to make comment.
• Value 1 is ‘Poor’ which refers to CGPA 1.00
• Value 2 is ‘Average’ which refers to CGPA 2.00
• Value 3 is ‘Good’ which refers to CGPA 3.00
• Value 4 is ‘Outstanding’ which refers to CGPA 4.00

I hope that helps. Please leave a comment below with any questions or suggestions. For more in-depth Excel training, checkout our Ultimate Excel Training Course here. Thank you!