Skip to content

Learn About the CHOOSE Function

This article will teach you all about the CHOOSE function and how to use it.

The CHOOSE function is available in both Google Sheets and Microsoft Excel.

What Does it Do?

The CHOOSE function returns an item from a list of arguments depending on the chosen index number. For example, you can use the CHOOSE function to return the 3rd color from a list of colors.

How it Works (Syntax)

The CHOOSE function accepts up to 255 arguments in Excel and 30 in Google Sheets. The arguments are as follows.

=CHOOSE(Index_num, Value1, Value2, etc.)
  • Index_num – This may be a number or a reference to a cell containing a number from 1 to the number of remaining arguments.
    • The number determines which argument is chosen and returned by the function.
    • This argument is required.
  • Value1 – This argument may be a hard-coded value or cell reference. 
    • It is the value returned if the Index_num is 1.
    • This argument is required.
  • Value2Value3etc. – These arguments may be hard-coded values or cell references.
    • These are the possible return values if the Index_num is 2, 3, etc.
    • These arguments are optional.

Example 1 – Return the Weekday

In this first example, the CHOOSE function returns a specific weekday depending on the chosen index number.

The first argument references the cell containing the chosen index number.

The remaining arguments reference cells containing the possible return values.

The index number happens to be 4, so the fourth value is returned. In this case, this is the value in A4, to the CHOOSE function results in “Wednesday.”

Example 2 – Determine the Sum Range

In this example, the CHOOSE function returns a range which is then passed to the SUM function to get a final total.

The first argument references the cell containing the chosen index number.

The second and third arguments reference two different ranges.

The index number of 2 results in the CHOOSE function returning the range B2:B5, which passes to the SUM function. The SUM function then calculates the final total.

And that is how you can use the CHOOSE function in Microsoft Excel and Google Sheets.

This Post Has One Comment

  1. This is why I love this blog! I never knew that this was an option and now it’s going to make my work life so much easier! Thanks for the post!

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top