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 https://amzn.to/3Rg87Go

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!

LinkedIn ► https://www.linkedin.com/company/18737946/
Instagram ► https://www.instagram.com/computergaga1/
Twitter ► http://www.twitter.com/computergaga1