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