CHOOSE
Chooses a value from a list of values based on an index number
Syntax
CHOOSE(index_num, value1, [value2], ...)
Parameters
- index_num: Required. Specifies which value argument is selected (1 returns value1, 2 returns value2, etc.)
- value1: Required. The first value from which to choose
- value2: Optional. Additional values, from 2 to 254
Example
=CHOOSE(2, "red", "blue", "green")