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.