The INDEX function returns the value in a list that is in the position given by number. The list can be numbers, text, cell addresses, ranges, and cell names. Ability searches the list and returns the value that occurs in the specified position.
For example,
INDEX(2, 1, 15, 20, 30, 35, 40)
returns 15, which is in the second position in the list.
See also: