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-... 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: / exceloffthegrid #MsExcel
Easiest Multi-Level Drop-Down Lists in Excel!
The Excel Lookup Battle: FILTER Takes on XLOOKUP... Who Will Win!!!
Using SUMIFS with arrays | Excel problem... Solved! | Excel Off The Grid
![The Advanced Excel Method Nobody Told You About [The DROP REDUCE LAMBDA STACK Combo]](https://i.ytimg.com/vi/kBhRyXkqefI/hqdefault.jpg?sqp=-oaymwEjCNACELwBSFryq4qpAxUIARUAAAAAGAElAADIQj0AgKJDeAE=&rs=AOn4CLDxDuIj0ITRQImNVCDCVV3dr3Z09A)
The Advanced Excel Method Nobody Told You About [The DROP REDUCE LAMBDA STACK Combo]
Drop‑Down Lists From Tables: Stop Using INDIRECT (Do This Instead)
XLOOKUP Spilling Secret: How to fix the array of arrays problem!
Next level FILTER Function tricks | Excel Off The Grid
The XLOOKUP trick nobody talks about (and it's GENIUS)
10 Advanced XLOOKUP Tips & Tricks
SCAN Solves Advanced Excel Problems in a Single Cell
STOP Making Basic Drop-Downs! Try These 5 Advanced Methods Instead
New Xlookup Function: A Vlookup Comparison
The Ultimate LOOKUP Guide (XLOOKUP, VLOOKUP, HLOOKUP and more)
XLOOKUP Complete Tutorial in Excel (+ Hidden Tricks)
10 Excel Formula Symbols You Wish You Knew Years Ago
Excel XLOOKUP Function – Comprehensive Lessons – 27 Examples - Excel Magic Trick 1600
Try The DGET Function Instead of INDEXMATCH & XLOOKUP
The Only VLOOKUP Guide You’ll Ever Need. (No More Errors)
Power Query was HARD until I learned these 7 Tips
