Formula Library

INDEX

lookup

Returns the value of a cell in a range, given a row and column number.

Syntax

=INDEX(array, row_num, [col_num])

Example

Excel
=INDEX(A1:C10, 3, 2)

Returns the value in row 3, column 2 of the range A1:C10.

Tips & Notes

  • →Combined with MATCH for powerful lookups
  • →Row or column can be 0 to return entire row/column
  • →Can reference multiple areas

See Also

INDEX/MATCHMATCH

Need a custom INDEX formula?

Describe exactly what you need and get the formula generated instantly.

Generate →

We use cookies and display ads via Google AdSense to keep ExcelBossPro free. Privacy Policy. By continuing, you accept our use of cookies.