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