MS Excel INDEX function The INDEX function returns a value or the reference to a value from within a table or range.