Skip to content
Excel

INDEX function in Excel

Uses an index to choose a value from a reference or array

=INDEX(array, row_num, [column_num])

INDEX syntax and parameters

Three arguments, two required.

  • arrayarrayRequired
  • row_numnumberRequired
  • column_numnumberOptional

INDEX examples

Formulas you'll actually reuse.

  1. The classic INDEX/MATCH — the amount on the row where the customer matches:

    =INDEX(C2:C200, MATCH("Acme Corp", A2:A200, 0))

    Result12400

  2. Two-way lookup: the row from a customer name, the column from a header:

    =INDEX(A2:F200, MATCH(H2, A2:A200, 0), MATCH(H3, A1:F1, 0))

    Result"Paid"

INDEX in Google Sheets

Same name — your formula ports as-is.

Try INDEX in the playground

Edit the example — nothing to install.

Preloaded with the INDEX formula from Example 1 — change anything and watch it respond.

Loading the editor…

INDEX errors

What they mean — and the fixes.

  • #REF!

    row or column is outside the array — INDEX counts from 1 inside the range you passed, not from the sheet's own row numbers.

Related functions

More ways Excel gets this done.