The Excel function: INDEX
Returns a value or the reference to a value from within a table or range. There are two forms of the INDEX function: the array (array: Used to build single formulas that produce multiple results or that operate on a group of arguments that are arranged in rows and columns. An array range shares a common formula; an array constant is a group of constants used as an argument.) form and the reference form.
|If you want to||Then see|
|Return the value of a specified cell or array of cells||Array form|
|Return a reference to specified cells||Reference form|