What is indexing?

3 Answer(s)


In simple terms, INDEX formula gives us value or the reference to a value from within a table or range.

indexing returns a value or the reference to a value from with in a table or range these having two forms of index the array form and the reference form

indexing helps in retaining value or the reference to a value from within a table or range. There are two forms of the INDEX function: the array form and the reference form.