CHOOSE

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.