Syntax. CHOOSE(index,value1,value2,...)

Definition. This function uses an index to return a value from the value argument list.

Arguments

Background. The index argument must evaluate to an integer from 1 through 29 or 1 through 254.

You can use a formula or reference to a cell returning such a number. If index is smaller than 1 or greater than the number of value arguments in the list, the CHOOSE() function returns the #VALUE! error. If index is a fraction, the decimal places are truncated before a value is returned.

You can use CHOOSE() in an array formula if you specify the index as an array. But take care to avoid errors: The formula

{=CHOOSE({1;2},SUM(E41:G41),SUM(E42:G42))}

returns the sum of E41 through G41 in the first cell, and the sum of E42 and G42 in the second cell. The formula

{=SUM(CHOOSE({1;2},E41:G41,E42:G42))}

returns the total of E41 through G42 in both cells. The formulas

=SUM(CHOOSE(1,E41:G41,E42:G42))

and

=SUM(CHOOSE(2,E41:G41,E42:G42))

return the correct results.

Example. Assume that you have entered the names of the days, starting with Sunday, in cells B42 through B48. The formula

="Today is " & CHOOSE(WEEKDAY(D42),B42,B43,B44,B45,B46,B47,B48) & "."

returns Today is [weekday name].