Apple numbers User Manual

 Dictionary of Functions

 

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.

  

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.

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.