 # How To Use CHOOSE()

Description

Returns an element from a list of choices based on index.

Common questions about the CHOOSE formula:

1. What does the CHOOSE formula do?
2. How do I use the CHOOSE formula?
3. What values can I input into the CHOOSE formula?

How can the CHOOSE formula be used appropriately?

The CHOOSE formula in Google Sheets can be used to return a value from a sequence, pick a random item from a list, or simplify more complex formulas by using its index-match capabilities.

How can the CHOOSE formula be commonly mistyped?

Many people mistakenly type "CHOOS", or CHOSE, or CHSE, instead of CHOOSE which throws an error in Google Sheets.

What are some common ways the CHOOSE formula is used inappropriately?

The CHOOSE formula should not be used when trying to sum up the contents of a range of cells as it will only return the first value of the listed range.

What are some common pitfalls when using the CHOOSE formula?

Common pitfalls when using the CHOOSE formula include forgetting to include the closing bracket at the end of the formula, forgetting to specify the list of choices, and providing an index that is out of range of the list of choices specified.

What are common mistakes when using the CHOOSE Formula?

Common mistakes when using the CHOOSE formula include using cells in the formula instead of the numerical value, forgetting to specify the list of choices, and providing an index that is out of range of the list of choices specified.

What are common misconceptions people might have with the CHOOSE Formula?

A common misconception about the CHOOSE Formula is that it can sum up the contents of a range of cells, when in fact it only returns the first value of the listed range. Additionally, some users think that the CHOOSE Formula can be used to select a random item from a list, when in reality it can only select a specific item from a list.

How To Actually Use CHOOSE() in Sheets

`CHOOSE(index, choice1, [choice2, ...])`

0Better Sheets Tutorials

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Find more formulas here at Better Sheets.

How to use the CHOOSE formula in Google Sheets

The Google Sheets CHOOSE formula allows us to pick a value from a set of values.

Better Sheets