CHOOSE ( index , argument-list )

Description: Selects the argument in argument-list that corresponds by position to index.

Arguments:

Name	Type	Description
index	number	An index into argument-list, truncated to an integer. The value of index shall be in the position range 1–n, where argument-1 is position 1, argument-2 is position 2, and so on up to argument-n. If index is an array, the value or every element in that array is evaluated, and if the formula was array-entered, the result is an array of chosen values.
argument-list	any	The arguments in any given argument-list need not all have the same type.

Return Type and Value: any, including array – The argument in argument-list that corresponds by position to index.

However, if the value of index is not an index into argument-list, #VALUE! is returned.

[Example:

CHOOSE(E7,F7,G7,H7,I7,J7,K7,L7) results in Monday, when E7 contains 2, and the cells F7:L7 each contain the names of the week, from Sunday to Saturday

SUM(CHOOSE(E1,F20:G20,H20:J24)) results in the sum of the elements designated by F20:G20 or H20:J24, as determined by the value of E1

If B9:B11 contain 1, 3, and 3, respectively, and CHOOSE(B9:B11,10,20,30) is array-entered into 3 cells, the values of those 3 cells is 10, 30, and 30, respectively.

end example]