Google Sheets CHOOSE Function

This post will guide you how to use Google Sheets CHOOSE function with syntax and examples.


The Google Sheets CHOOSE function returns a value from a list of values based on index. For example, =CHOOSE(2,”google”,”sheets”,”book”) returns “sheets” value, and “sheets” value is the second value listed after the index number in this formula.

The CHOOSE function can be used to get a value from a list using a given index in google sheets. The purpose of this function is to get a value from a list based on a index and the returned value is the value at the given position.

The CHOOSE function is a build-in function in Google Sheets and it is categorized as a Lookup function.


The syntax of the CHOOSE function is as below:

=CHOOSE (index_num, value1,[value2],…)

Where the CHOOSE function arguments are:

  • index_num -This is a required argument. Specify the position number in the list of values.
  • Value1,[value2] – This is a required argument.  A list of one or more values that you want to return


  • The index_num value must be a number between 1 and 29.
  • If index_num value is less than 1 or greater than the length of the value list, the CHOOSE function will return #NUM!Error value.
  • CHOOSE function will not retrieve values from a given range or array range
  • Values can be an actual value or a cell reference.

Google Sheets CHOOSE Function Examples

The below examples will show you how to use google sheets CHOOSE Function to return a value from a value list based on a position value.

#1 To get the second value in the value list in B1 Cell, just using the following formula:


google sheets choose function1

#2 CHOOSE function will not retrieve values from a cell range, and it will return a #NUM! Error, like the below formula:


google sheets choose function1

#3 INDEX number is out of range in CHOOSE formula, it will retrun a #NUM! error, like:


google sheets choose function1