Spread Formula Reference
Formula Functions / Functions H to L / INDEX
In This Topic
    INDEX
    In This Topic

    This function returns a value or the reference to a value from within an array or range.

    Syntax

    INDEX(return,row,col,area)

    Arguments

    The arguments are as follows, and are truncated if not integers:

    Argument Description
    return Returns a value or a reference of a cell or range of cells
    row Row number in the range
    col Column number in the range
    area [If return is a cell range reference] Area of the range

    Data Types

    Accepts numeric data. Returns numeric data.

    Examples

    INDEX(A2:C3,2,2)

    INDEX(R2C1:R3C3,5,3)

    Version Available

    This function is available in product version 1.0 or later.

    See Also

    CHOOSE | Lookup Functions