INDEX / MATCH
A flexible two-function lookup that can return values to the left of the lookup column.
INDEX returns a value at a position; MATCH finds that position. Combined, they look up in any direction and outperform VLOOKUP on large sheets.
Excel
=INDEX(B:B, MATCH(D2, A:A, 0))Google Sheets
=INDEX(B:B, MATCH(D2, A:A, 0))How it works
- 1MATCH(D2, A:A, 0) finds the row where A equals D2.
- 2INDEX(B:B, …) returns the value from B in that row.
- 30 in MATCH means exact match.