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

Table of Contents

**Description**

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

**Syntax**

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

**Note: **

- 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:

=CHOOSE(2,A1,A2,A3)

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

=CHOOSE(2,A1:A3)

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

=CHOOSE(4,A1,A2,A3)