How to Use XLOOKUP in Excel – Step-by-Step Tutorial for Beginners скачать в хорошем качестве

How to Use XLOOKUP in Excel – Step-by-Step Tutorial for Beginners

Discover how to master XLOOKUP in Excel with this beginner-friendly tutorial! If you’ve been searching for a modern alternative to VLOOKUP, XLOOKUP is here to simplify your workflows. This video breaks it down step-by-step, making it easy to follow along and upgrade your Excel skills. First, we’ll introduce the XLOOKUP function by showing how it can replace manual entry for filling in order amounts. Next, you’ll learn how to enter the formula, including the lookup value, lookup array, return array, and optional parameters like "if_not_found" and match modes. Then, we’ll explore the formula help tool, using the Fx icon to get insights into function parameters and preview results. After that, we’ll show you how to fill the formula down across rows, using absolute references to lock key cells. Next, we’ll tackle the issue of adding rows by converting data to table references, ensuring your formula remains dynamic. Finally, we’ll demonstrate how to use XLOOKUP for horizontal lookups, perfect for transposed data like monthly reports. By the end of this Excel tutorial, you’ll have the skills to confidently use XLOOKUP. Ready to dive into the Excel app and see why it’s the big brother of VLOOKUP? Hit play and follow along! Host: David DeWinter 📚 RESOURCES Download the practice workbook to follow along ➜ https://kevstrat-my.sharepoint.com/:x... ⌚ TIMESTAMPS 0:00 - Intro: Master XLOOKUP in Excel 0:53 - #1: Entering the XLOOKUP Formula 1:38 - #2: Understanding lookup_array and return_array 2:30 - #3: Tackling if_not_found, match_mode, search_mode 4:24 - #4: Using Formula Help for Parameters 4:50 - #5: Copying XLOOKUP Across Rows 6:15 - #6: Horizontal Lookup with XLOOKUP 7:57 - A Final Question for You 📩 NEWSLETTER Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: https://kevinstratvert.com/newsletter/ 🔽 CONNECT WITH ME Official website: http://www.kevinstratvert.com LinkedIn:   / kevinstratvert   Discord: https://bit.ly/KevinStratvertDiscord Twitter:   / kevstrat   Facebook:   / kevin-stratvert-101912218227818   TikTok:   / kevinstratvert   Instagram:   / kevinstratvert   🎁 TOOLS AND DISCOUNTS ✅ 🎙️ Voicemod AI Voice Changer | 5% off | https://link.xsolla.com/KZBi89AY ✅ 🌐 Squarespace Websites | https://squarespace.syuh.net/XYaqYM ✅ 🔍 Grammarly | https://grammarly.go2cloud.org/SH3nL ✅ 📹 CapCut | https://bit.ly/installcapcut ✅ 🛍️ Shopify | https://shopify.pxf.io/XY9rPa ✅ 📋 Notion | https://affiliate.notion.so/rffva4tr71ax ✅ 🖼️ Figma | https://psxid.figma.com/lqjg97licpry ✅ 🤖 ElevenLabs Text-to-Speech | https://try.elevenlabs.io/taqepq60mptr ✅ 💵 Quickbooks Online | https://bit.ly/intuitquickbooksonline ✅ 👥 Hubspot | https://hubspot.sjv.io/DKo6jb ✅ 📈 Semrush PRO | https://bit.ly/semrush14dayfreetrial ✅ 📈 Semrush GURU | https://bit.ly/semrushguru14daytrial ✅ 📈 Semrush ContentShake AI | https://bit.ly/contentshakeaisemrush ✅ 🎥 Descript | https://get.descript.com/sf22jb63w2tx ✅ 🏓 Smartsheet | https://bit.ly/trysmartsheet 🎒 MY COURSES Go from Excel novice to data analysis ninja in just 2 hours: https://kevinstratvert.thinkific.com/ 🙏 REQUEST VIDEOS https://forms.gle/BDrTNUoxheEoMLGt5 🔔 SUBSCRIBE ON YOUTUBE https://www.youtube.com/user/kevlers?... 🙌 SUPPORT THE CHANNEL Hit the THANKS button in any video! Amazon affiliate link: https://amzn.to/3kCP2yz ⚖ DISCLOSURE Some links are affiliate links. Purchasing through these links gives me a small commission to support videos on this channel. The price to you is the same. #stratvert #xlookup #excel