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.
🔻 DOWNLOAD EXCEL FILE INCL. STEP BY STEP WRITTEN INSTRUCTIONS: [ Ссылка ]
🎓 LEARN MORE in my Excel courses: [ Ссылка ]
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
💬 Please leave me a COMMENT. I read them all!
🧟♀️ CONNECT with Mynda on LinkedIn: [ Ссылка ]
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: [ Ссылка ]
⏲ 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
