Google Sheets reference

INDEX in Google Sheets

Works in Google Sheets1 worked example

Worked examples (1)

These formulas work in Google Sheets with identical syntax.

Lookup & Referenceadvanced

=INDEX(B2:E10,MATCH(H2,A2:A10,0),MATCH(H3,B1:E1,0))

Also in Excel

See the full INDEX reference for Excel — including all worked examples, common errors, and FAQ.