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 ➜
⌚ 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
🔽 CONNECT WITH ME
🎁 TOOLS AND DISCOUNTS
🎒 MY COURSES
🙏 REQUEST VIDEOS
🔔 SUBSCRIBE ON YOUTUBE
🙌 SUPPORT THE CHANNEL
- Hit the THANKS button in any video!
⚖ 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