Mastering VLOOKUP, HLOOKUP & XLOOKUP

You'll learn the pros and cons of the main lookup formulas. We'll start by discussing VLOOKUP and its useful applications, followed by HLOOKUP. We'll then highlight the main limitation of these two formulas: they only work if your data is to the right.
To address this, we'll introduce a solution using XLOOKUP, exploring five different scenarios where it can be useful, ranging from the simplest to the most complex:
- Basic XLOOKUP
- XLOOKUP with the "if not found" feature
- XLOOKUP match mode
- XLOOKUP with multiple criteria
- Nested XLOOKUPs (combining two XLOOKUPs)
- We'll cover the limitations of XLOOKUP and propose a more complex solution involving a nested FILTER and SUM formula.
Download the excel workbook here: 1drv.ms/x/c/fa...

[@MasterX14]

Thanks for sharing.

[@DarkGaming-2734]

Amazing!