Spread Formula Reference
Formula Functions / Functions A to C / CHOOSE
In This Topic
    CHOOSE
    In This Topic

    This function returns a value from a list of values.

    Syntax

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

    Arguments

    This function has these arguments:

    Argument Description
    index Index of the specified values to return; an integer value between 1 and 255
    value1, etc. Values from which to choose; can have up to 255 values; can be numbers, cell references, cell ranges, defined names, formulas, functions, or text

    The value arguments can be range references as well as single values. For example, the formula:

       SUM(CHOOSE(2,A1:A25,B1:B10,C1:C5))

    evaluates to:

       SUM(B1:B10)

    which then returns a value based on the values in the range B1:B10.

    Remarks

    This function is evaluated first, returning the reference B1:B10. The SUM function is then evaluated using B1:B10.

    Data Types

    The index argument accepts numeric data. The value arguments accept any data. Returns the type of data of the specified value.

    Examples

    CHOOSE(3,A1,B1,C1,D1,E1) gives the result C1

    CHOOSE(3,R1C1,R1C2,R1C3,R1C4,R1C5) gives the result R1C3

    CHOOSE(2,"dogs","birds","fish","cats","mice") gives the result birds

    Version Available

    This function is available in product version 1.0 or later.

    See Also

    INDEX | SUM | Lookup Functions