Скачать с ютуб Excel XLOOKUP Function Definitive Guide - Replaces VLOOKUP, INDEX&MATCH & HLOOKUP в хорошем качестве

Excel XLOOKUP Function Definitive Guide - Replaces VLOOKUP, INDEX&MATCH & HLOOKUP

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: https://www.myonlinetraininghub.com/e... 🎓 LEARN MORE in my Excel courses: https://www.myonlinetraininghub.com/ 🔔 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:   / myndatreacy   🎁 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: 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