Hellow guys, Welcome to my website, and you are watching Excel XLOOKUP Function Definitive Guide - Replaces VLOOKUP, INDEX&MATCH & HLOOKUP. and this vIdeo is uploaded by MyOnlineTrainingHub at 2020-01-07T15:00:01-08:00. We are pramote this video only for entertainment and educational perpose only. So, I hop you like our website.
| Name | Excel XLOOKUP Function Definitive Guide - Replaces VLOOKUP, INDEX&MATCH & HLOOKUP |
| Video Uploader | Video From MyOnlineTrainingHub |
| Upload Date | This Video Uploaded At 07-01-2020 23:00:01 |
| Video Discription | 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/excel-xlookup-function 🎓 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: https://www.linkedin.com/in/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/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 |
| Category | Science & Technology |
| Tags | Science & Technology Download MP4 | Science & Technology Download MP3 | Science & Technology Download MP4 360p | Science & Technology Download MP4 480p | Science & Technology Download MP4 720p | Science & Technology Download MP4 1080p |
