Ultimate XLOOKUP Guide: 10 Tips You Need to Know!

★ Want to automate Excel? Check out our training academy ★ https://exceloffthegrid.com/academy ★ Get the example file ★ Sign up for our free Insiders program and get the example file: https://exceloffthegrid.com/insiders-signup/ File Reference for this video: 0233 XLOOKUP.zip ★ About this video ★ You probably already know that XLOOKUP is Excel's new lookup function. It's making VLOOKUP a thing of the past. But how well do you know XLOOKUP? In this video, we are going deep and looking at 10 examples of using XLOOKUP, so you can master your data and save more time. 0:00 Introduction 0:23 Basic syntax 1:29 [1] If not found 2:15 [2] Multi-column lookup 3:29 [3] Scalar lifting 4:22 [4] Range function 5:57 [5] Wildcard search 7:39 [6] Range lookup 9:06 [7] Find last 10:12 [8] Return multiple values 10:53 [9] Horizontal lookup 11:30 [10] 2-Way lookup ★ Download 30 most useful Excel VBA Macros ebook for FREE ★ https://exceloffthegrid.com/ ★ Where to find Excel Off The Grid ★ Blog: https://exceloffthegrid.com Twitter: https://twitter.com/exceloffthegrid #MsExcel