Excel Index

The INDEX function returns the nth item in an array.


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)


CategoryRicottone

Excel/Index (last edited 2025-04-08 16:49:29 by DominicRicottone)