INDEX

INDEX —

INDEX(array[,row, col, area])

INDEX gives a reference to a cell in the given array.The cell is pointed out by row and col, which count the rows and columns in the array.

If row and col are omitted the are assumed to be 1.
If the reference falls outside the range of the array, INDEX returns a #REF! error.

Let us assume that the cells A1, A2, ..., A5 contain numbers 11.4, 17.3, 21.3, 25.9, and 40.1. Then INDEX(A1:A5,4,1,1) equals 25.9