FUNCTION CATALOGUE / LOOKUP & REFERENCE
CHOOSE Excel function
Chooses a value from a list by index.
Correct sentence to use
Return option [index] from [options].
Modify this query in PlainFormula →Example formula
=CHOOSE(2,"Red","Blue","Green")
Returns the selected argument.
Syntax
CHOOSE(index_num, value1, [value2], …)
Argument signature: index_num, value1, [value2], …
Availability note
Commonly available in current Excel; verify platform and locale-specific behaviour.