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.