The CHOOSE function in Google Sheets is a versatile tool that allows users to select a value or action from a list of options based on a specified index number. This function is particularly useful when working with dynamic data sets where the selection criteria may change, enabling users to streamline their decision-making process with ease.

Syntax

CHOOSE(index, choice1, choice2, ..., choiceN)

• index: A numeric value that determines which element to retrieve from the list of choices.
• choice1: The first choice from which the function can select.
• choice2: The second choice to select from.
• choiceN: Additional choices available for selection, where N can be any number of arguments.

Example #1

CHOOSE(2, "Apple", "Banana", "Cherry")

This call returns “Banana” because it is the second item in the provided list of choices.

Example #2

CHOOSE(1, 100, 200, 300)

In this instance, the function retrieves “100” as it is the first item in the choices.

Example #3

CHOOSE(4, TRUE, FALSE, "No", "Yes")

This function call will return “Yes”, the fourth item in the list.

Error handling

• VALUE!: This error occurs when the index is less than 1 or greater than the number of choices provided.
• REF!: Occurs when a non-existent range is referenced, often due to an invalid argument in the function call.
• N/A: This might result from an index that points to a choice that is not available in the selection list.

Conclusion

The CHOOSE function is an essential tool in Google Sheets for selecting among a variety of choices based on a dynamic index. With its simple syntax and straightforward application, it can enhance your ability to manage data effectively and make informed decisions.