Using XLOOKUP with other Excel Functions - INDEX, SUMIF and SUM

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. Introduction to the XLOOKUP function - https://youtu.be/KRuVF3JliXI 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; https://www.computergaga.com *** Online Excel Courses *** The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel Excel VBA for Beginners ► http://bit.ly/2JvnnRv Advanced Excel Tricks ► https://bit.ly/3CGCm3M Excel Formulas Made Easy ► http://bit.ly/2t3netw Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2viGg3J Connect with us!