Excel INDEX function tutorial (array)

The Excel INDEX function returns the value of a cell. The INDEX function is often confused with the Excel OFFSET Function. The INDEX function is part of a larger group of Excel lookup functions which includes MATCH, VLOOKUP and HLOOKUP.

In this tutorial we will explore the INDEX function and how it compares to the OFFSET function and potential errors that can occur when using this function.