VLOOKUP in Excel | Tutorial for Beginners скачать в хорошем качестве

VLOOKUP in Excel | Tutorial for Beginners

In this step-by-step tutorial, learn how to use VLOOKUP, HLOOKUP, AND XLOOKUP in Microsoft Excel. With VLOOKUP, you can find things in a table or a range by row. For example, look up a price of an automotive part by the part number, or find an employee name based on their employee ID. 👋 Additional resources: Sample file to follow along: https://1drv.ms/x/s!AmxrofZZlZ-whK4bP... Learn the fundamentals of Excel in just 2 hours: https://kevinstratvert.thinkific.com ⌚ Timestamps 0:00 Introduction 1:47 Organize data properly for VLOOKUP 5:38 VLOOKUP Exact match 9:34 Improve error message with IFERROR 11:10 VLOOKUP Closest match 14:48 VLOOKUP Across sheets 15:43 HLOOKUP 18:21 XLOOKUP Simple example 22:53 XLOOKUP Combined with other functions 24:54 XLOOKUP Returns an array 26:42 XLOOKUP Match modes 28:30 XLOOKUP Search modes 31:24 Wrap up 📃 Watch related playlists and videos Playlist with all my videos on Excel:    • ❎ How to use Excel   📩 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 ✅ 🛍️ 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 🎒 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 #vlookup #excel