CHOOSE

CHOOSE —

CHOOSE(index[,value1][,value2]...)

CHOOSE returns the value of index index. index is rounded to an integer if it is not.

If index < 1 or index > number of values, CHOOSE returns #VALUE! error.

CHOOSE(3,"Apple","Orange","Grape","Perry") equals "Grape".