Excel XLOOKUP Function Examples - 8 Useful XLOOKUP Examples

In this video, we look at 8 Excel XLOOKUP function examples to show off the power and versatility of this brilliant Excel function. Learn ALL the best Excel functions - https://amzn.to/3Rg87Go You can download the file to follow along here - https://www.computergaga.com/_excel/files/xlookup-examples.xlsx Here are the chapters of the video contents; 00:00 Introduction 00:34 Classic XLOOKUP and dynamic array behaviour 03:12 Range lookup with XLOOKUP 05:32 Rank the top 5 products by sales value 07:52 Return the last match in a list 09:27 Two way lookup with two XLOOKUPs 12:23 Multiple criteria lookup 14:08 Interactive chart 17:02 XLOOKUP to help a complex COUNTIF We start with a typical XLOOKUP example to look up some data and then progress through a variety of scenarios where XLOOKUP helps achieve our goal easily. These include ranking values, creating dynamic charts, analysing with COUNTIF and performing a lookup with multiple criteria. This function is a great VLOOKUP alternative. But also a great alternative to HLOOKUP and the INDEX/MATCH combination. By the end of these Excel XLOOKUP function examples, you will know why we are all excited about this Excel function. 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/37XSKfZ Advanced Excel Tricks ► https://bit.ly/3CGCm3M Excel Formulas Made Easy ► http://bit.ly/2ujtOAN Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm Connect with us! LinkedIn ► https://www.linkedin.com/company/18737946/ Instagram ► https://www.instagram.com/computergaga1/ Twitter ► http://www.twitter.com/computergaga1