In this video, we look at how to use XLOOKUP with other functions such as INDEX, SUMIF and SUM.
XLOOKUP can return a range as well as values, and this creates lots of possibilities for advanced uses.
Learn more than 150 of the best Excel functions with my 'Advanced Excel Formulas' book [ Ссылка ]
Introduction to the XLOOKUP function - [ Ссылка ]
XLOOKUP can be used with any other Excel function that requires a range or a value to perform a task.
Find more great free tutorials at;
[ Ссылка ]
*** Online Excel Courses ***
The Ultimate Excel Course – Learn Everything ► [ Ссылка ]
Excel VBA for Beginners ► [ Ссылка ]
Advanced Excel Tricks ► [ Ссылка ]
Excel Formulas Made Easy ► [ Ссылка ]
Creating Sports League Tables and Tournaments in Excel ► [ Ссылка ]
Connect with us!
LinkedIn ► [ Ссылка ]
Instagram ► [ Ссылка ]
Twitter ► [ Ссылка ]
![](https://i.ytimg.com/vi/k_sH_Vy_AXo/maxresdefault.jpg)