INDEX

Description

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.

Syntax

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.

Examples


INDEX