XLOOKUP — Excel guide
The modern lookup (Excel 2021+/365): exact match by default, looks any direction, built-in not-found handling. If you can require modern Excel, this replaces VLOOKUP, HLOOKUP, and most INDEX+MATCH.
XLOOKUP
Find a value in one range, return the matching item from another.
- search_mode -1 grabs the LAST match — the current price in an append-only log.
- match_mode -1 does tier/bracket lookups without requiring sorted data.
- Two-way lookup: nest one XLOOKUP as the other's return_array.
- Multi-criteria: =XLOOKUP(1, (A:A=x)*(B:B=y), C:C) — look up the row where both conditions score 1.
- A found-but-empty cell returns 0, not blank — wrap in LET if the difference matters.