If you’ve ever suffered the delights of lookup formulas using Excel functions like VLOOKUP, HLOOKUP, MATCH and INDEX, then you’re going to love these new functions.
- XLOOKUP versus VLOOKUP
- XMATCH versus MATCH
- Making approximate, exact and partial matches
- Returning 12 months of data with one XLOOKUP
- A Two-Way lookup with XLOOKUP