Скачать с ютуб I don't use VLOOKUP anymore. I use this instead.... в хорошем качестве

I don't use VLOOKUP anymore. I use this instead....

💥Get my XLOOKUP course & master this function 👉 https://chandoo.org/wp/lookups-for-da... VLOOKUP is the most used Excel function out there. But here is a secret. I no longer use it!!! That is right. I broke up with VLOOKUP. I use XLOOKUP now. It is a new function in Excel 365. So in this video, let me introduce you to my new crush 😍 - The XLOOKUP. In this video, learn all about: 👉 What is XLOOKUP and how it's better than VLOOKUP 👉 Using XLOOKUP in business situations 👉 Errors & XLOOKUP (if not found option) 👉 XLOOKUP with tabular data 👉 Wildcard (pattern) matching with XLOOKUP 👉 Returning multiple values with XLOOKUP 👉 XLOOKUP vs. HLOOKUP Video topics ⏱👇 ============== 0:00 - VLOOKUP & XLOOKUP - Quick examples 2:13 - Difference between VLOOKUP & XLOOKUP 2:30 - Using XLOOKUP instead of INDEX + MATCH 3:32 - Dealing with Errors (#N/A) using XLOOKUP 4:57 - XLOOKUP with Tabular Data (tables) 5:40 - Wild card (pattern matching) with XLOOKUP 7:40 - Returning multiple values with XLOOKUP 9:10 - XLOOKUP works horizontally too!!! Example file (with many many XLOOKUPs) 🟩👉 ======================================= Here is a sample file with many many XLOOKUP examples - https://chandoo.org/wp/wp-content/upl... If you want more, check out this article: https://chandoo.org/wp/xlookup-examples/ Or join my mini-course on various lookup functions in Excel here - https://skl.sh/3hbR49d Watch next 👨‍💻👩‍💻👉 ================ FILTER function -    • I don’t use filters in Excel anymore....   Spill Behaviour in Excel (# operator) -    • Excel Dynamic Arrays and How to use t...   VLOOKUP explained -    • Excel VLOOKUP  - Complete tutorial & ...   INDEX+MATCH explained -    • Excel's INDEX + MATCH - How to use it...   #excel #xlookup ~ What does Charles Xavier use to find mutants? XLOOKUP of course 🤣