Picks out a value or expression based on the index.
Syntax
CHOOSE(index,expression,{expression})
Arguments
Index Which expression to use. To use the first expression, enter 1, to use the second, enter 2, and so forth. If the index value is less than 1 or greater than the number of expression, the function returns the error #ARG! expression The value or references to use in the evaluation. Example
CHOOSE(2,A2,B4,C9)
This function returns the value of the cell B4 since it is the second expression in the series.