Скачать с ютуб VLOOKUP vs. XLOOKUP in Excel в хорошем качестве

VLOOKUP vs. XLOOKUP in Excel

In this video, you’ll dive deep into the differences between the XLOOKUP and the VLOOKUP functions in Excel and why you should use one over the other. XLOOKUP and VLOOKUP are both lookup functions that look up information in a data table, but one is superior in many ways. Here are some of the topics I cover in this video: 1. How to use VLOOKUP 2. How to use XLOOKUP 3. Differences in search capabilities 4. Differences in approximate search capabilities 5. Differences in returning value capabilities 6. Which function is less prone to user errors 📹WATCH EXCEL DICTIONARY'S FULL XLOOKUP VS. VLOOKUP SERIES Part 1: How to Use VLOOKUP in Excel:    • How to Use VLOOKUP in Excel (From Beg...   Part 2: How to Use XLOOKUP in Excel:    • How to Use XLOOKUP in Excel (From Beg...   Part 3: XLOOKUP vs. VLOOKUP: 👆🏼 📖RESOURCES - Download this workbook and follow along: https://excel-dictionary.com/pages/yo... 🤓SHOP EXCEL DICTIONARY - COURSES: https://excel-dictionary.com/collecti... -GUIDES: https://excel-dictionary.com/collecti... -MERCH: https://excel-dictionary.com/collecti... -TEMPLATES: https://excel-dictionary.com/collecti... 📩NEWSLETTER -Unlock the full potential of Excel and PowerPoint with expert tips delivered to your inbox each week: https://www.excel-dictionary.com/subs... 📺SUBSCRIBE -Subscribe to never miss a video:    / exceldictionary   🕰️TIMESTAMPS ‘0:00 Intro ‘0:20 How to use VLOOKUP ‘0:40 How to use XLOOKUP ‘1:05 Which function should you use? ‘1:27 Differences in search capabilities ‘2:57 Differences in approximate search capabilities ‘4:02 Differences in returning value capabilities ‘5:21 Which function to use to avoid user errors ‘5:54 Compare and contrast LOOKUP chart ‘6:13 Wrap Up #excel #exceltips