CHOOSE

CHOOSE — the (index+1)th argument

CHOOSE(index,value1,value2,…)

index: positive number

value1: first value

value2: second value

CHOOSE returns its (index+1)th argument.

index is truncated to an integer. If index < 1 or the truncated index > number of values, CHOOSE returns #VALUE!

Synopsis