CHOOSE Formula in Excel
Monday, Jul 06
commerce curve online accounting course

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.


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).


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!



Learn 10 great Excel techniques that will wow your boss and make your co-workers say, “how did you do that??”
Plus weekly updates to help you learn Excel.

Download the eBook

Contact Us

Please reach out to us with questions and comments using the form.
Commerce Curve.

3 + 10 =