Excel How-to
XLOOKUP with Multiple Criteria in Excel and Google Sheets
Look up a value with two conditions in XLOOKUP: concatenate the keys, or multiply boolean tests. In Google Sheets both methods need ARRAYFORMULA.
#index-match
2 tutorials tagged “index-match”.
Excel Comparison
XLOOKUP vs INDEX MATCH vs VLOOKUP: Which Should You Use in 2026?
Use XLOOKUP in Excel 365 and Google Sheets; keep INDEX/MATCH for Excel 2019 and earlier. Defaults, left lookups, last match, and the approximate-match trap.