CHOOSE


Returns a value from a list, given an index number.

Syntax:

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

value1 ... value30 are up to 30 values, each of which may be text, a number, a logical value, a reference or a formula.
index is an index number specifying which of value1 ... value30 to return; 1 returns value1, 2 returns value2, etc.

Example:

CHOOSE(1, "dog", "cat")
returns the text dog.
CHOOSE(2, "dog", 65.4)
returns the number 65.4.
CHOOSE(3, "dog", 65.4, B5)
returns the reference B5, so that CHOOSE(3, "dog", 65.4, B5) in a cell shows the contents of cell B5 in that cell (it is equivalent to B5).
SUM(CHOOSE(1, B4:B5, B6))
returns the sum of the numbers in the range B4:B5.
CHOOSE(2, SUM(B1:C1), SQRT(9))
returns 3, the square root of 9.






 
Created with Zapof