CHOOSE

The CHOOSE function returns a value from a list of values based on a specified position.

Syntax

=CHOOSE(index, value1, [value2], ...)

Parameters

• index: The position of the value to return (starting from 1)
• value1: The first value in the list
• value2, ...: Additional values in the list (optional)

Examples

=CHOOSE(2, "A", "B", "C") // Returns "B"
=CHOOSE(1, 10, 20, 30) // Returns 10