= Excel Index =

The '''`INDEX`''' function returns the ''n''th item in an array.

<<TableOfContents>>

----



== Usage ==

To select a cell from a one-dimensional [[Excel/Arrays|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