Apple Numbers '08 - Manual (Page 237)

Chapter 12 Dictionary of Functions 237
INDEX
The INDEX function retrieves the value in the cell located at the intersection of the
specified row and column within a range of cells. You specify the location by indicating
how many rows down and how many columns to the right the cell is in relation to the
upper-left corner of the range.
INDEX(cell-range, [row], [column], [area])
 cell-range: A range or list of ranges containing the values you want to return. If more
than one range is given (specified in a list surrounded by parentheses), the area
argument specifies which range to give a result from.
 row: Optional; the number of the cell’s row, counting from top to bottom with the
topmost cell in the cell range numbered 1. If omitted, you must include column.
 column: Optional; the number of the cell’s column, counting from left to right with
the leftmost cell in the cell range numbered 1. If omitted, you must include row.
 area: Optional; the number of the area in cell-range if it includes more than one.
INDIRECT
The INDIRECT function returns a reference to an address specified as a string.
INDIRECT(address, [style])
 address: A string representing a cell address or a reference to a cell that contains a
cell address.
 style: Optional; address style used in address.
TRUE, 1, or omitted indicates the A1 style address.
FALSE or 0 returns an error indicating that the R1C1 style isn’t supported.
Examples
Given the following table:
INDEX(B2:E5,1,1) returns 2.
INDEX(B2:E5,3,2) returns 1024.
INDEX(B2:E5,2,3) returns 128.
INDEX(B2:E5,1,5) returns an error because the range contains only four columns.