Excel Index
The INDEX function returns the nth item in an array.
Contents
Usage
To select a cell from a one-dimensional range, try:
=INDEX(A1:A10,3)
For a two-dimensional range, two indices must be specified. They are ordered specifically as row then column. For example, to get the 3rd column and 4th cell, try:
=INDEX(A1:D10,3,4)