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:
#2 CHOOSE function will not retrieve values from a cell range, and it will return a #NUM! Error, like the below formula:
#3 INDEX number is out of range in CHOOSE formula, it will retrun a #NUM! error, like: