INDEX function to return a value from a specified position in a range/array

You can return the value in a range/array or table by using the INDEX function.

The function is built as follows

=INDEX(RangeToCheck, RowNumber, ColumnNumber)

The above is demonstrated in the example below where the value in row 3 and column 2 of the specified range (A2 to B4) is returned

INDEX

Get more great content from Rousseau Associates

Start your project with us today

Call +44 (0)1757 269461

Discuss your requirements today