INDEX and MATCH

Also known as · INDEX MATCH

A pairing where MATCH finds a position and INDEX returns the cell at that position. Two MATCH calls (one for the row, one for the column) give a two-way lookup.

When to use

Use it when the column also has to be found from a label, as with a student's grade on grade ex5; use XLOOKUP for a simple find-the-row lookup. The MATCH ranges and the INDEX array must start from the same cell, and write 0 in MATCH for exact match.

See Lec 06.

Appears in

No references yet.