Lookup & Referenceadvanced
Two-way lookup with INDEX and MATCH
=INDEX(B2:E10,MATCH(H2,A2:A10,0),MATCH(H3,B1:E1,0))
Worked examples (1)
These formulas work in Google Sheets with identical syntax.
Also in Excel
See the full INDEX reference for Excel — including all worked examples, common errors, and FAQ.
INDEX Excel reference →