Syntax: @CHOOSE(N, argumentlist)
N = a numeric value which should be <= the number of
items in argumentlist - 1
argumentlist = any combination of numbers, strings, or
cell addresses separated by commas.
@CHOOSE returns the Nth argument from the argument list, starting with an index of 0.
Examples:
@CHOOSE(2, D1, C22, F5, K1) = 54, where F5= 54
@CHOOSE(1, A9, D23, G12) = ``Peaches'', where D23 = ``Peaches''
@CHOOSE(3, ``nuts'', ``rings'', ``bolts'', ``fittings'') = ``fittings''
@SUM(@CHOOSE(A1>B1, B1..B10, A1..A10)) sums either column A or column B.