Скачать или смотреть XLOOKUP Complete Tutorial in Excel (+ Hidden Tricks)

The new XLOOKUP function is better, easier and faster than VLOOKUP, HLOOKUP, INDEX & MATCH and OFFSET...oh, and you also don't need IFERROR to hide errors because it's built in.
👩‍🏫 Master Excel with my courses: https://bit.ly/xlookup20courses

⬇️ Download the example file here and follow along: https://bit.ly/xlookup20file

LEARN MORE
===========

📰 EXCEL NEWSLETTER - join 450K+ subscribers here: https://www.myonlinetraininghub.com/e...

🎯 FOLLOW me on LinkedIn:   / myndatreacy  

💬 EXCEL QUESTIONS: Get help on our Excel Forum: https://www.myonlinetraininghub.com/e...

⏲ TIMESTAMPS
==============
0:00 How to use the XLOOKUP Function
1:01 XLOOKUP syntax
1:37 Simple XLOOKUP
2:53 XLOOKUP does HLOOKUP
4:17 XLOOKUP does INDEX & MATCH
7:14 XLOOKUP Returns Multiple Columns
11:18 XLOOKUP Dynamic Range
13:37 XLOOKUP Error Handling
14:45 XLOOKUP Last Value
16:13 XLOOKUP Left
17:18 XLOOKUP Wildcards
18:25 XLOOKUP Approximate Match

#Excel #XLOOKUP #ExcelFunctions