INDEX

Returns the value of a cell in a range based on the row and column offsets.

Syntax

INDEX(range,row-offset,column-offset)

Arguments

range	The range of cells to search.
row-offset	The row offset.  The first row in the range is always 1, the second is 2, and so forth.  If this value is less then 1 or greater than the number of rows in the defined range, then the function returns the error #REF!
column-offset	The column offset.  The first column in the range is always 1, the second is 2, and so forth. If this value is less then 1 or greater than the number of columns in the defined range, then the function returns the error #REF!

Example

INDEX(A2..D4,2,2)

This function returns the value of cell B3.  This cell is the intersection between the second row and second column in the range.