INDEX MATCH Practice

Freeintermediate 20 min4 tasks0/84 pts

More INDEX MATCH: look up by name or ID, fill a whole list, and use a two-way lookup where one MATCH finds the row and another finds the column from its heading.

Syntax

INDEX(table, MATCH(row_value, row_labels, 0), MATCH(col_heading, headings, 0))

Common mistakes

Not locking ranges with $ when filling down.
Matching against a range that includes the heading row.

INDEX MATCH Lookup Index Match Skill Summary