The Excel function: INDEX
Description
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 |