Learn Excel in just 2 hours: https://kevinstratvert.thinkific.com'>https://kevinstratvert.thinkific.com
In this stepbystep beginner's tutorial, learn how to use the XLOOKUP function in Microsoft Excel. With Excel XLOOKUP formula, you can look up values on the same worksheet or between multiple worksheets. For example, let's say I have a cookie name, chocolate chip, my favorite, and I want to know the price. I have another table with the prices. I can look up the cookie name and get the price back. We'll look at how this function works in the simplest form and then we'll look at more advanced capabilities. XLOOKUP is currently available to Microsoft 365 subscribes. If you don't have Microsoft 365, you can use VLOOKUP or HLOOKUP.
Additional resources
Sample spreadsheet to follow along: https://1drv.ms/x/s!AmxrofZZlZwhM4Ix...
How to use VLOOKUP in Excel Complete Tutorial: • VLOOKUP in Excel | Tutorial for Begin...
Learn the fundamentals of Excel in just 2 hours: https://kevinstratvert.thinkific.com'>https://kevinstratvert.thinkific.com
⌚ Timestamps
0:00 Introduction
1:13 Basic example of XLOOKUP
4:20 Show text when value is not found
5:11 Horizontal lists
5:45 Across worksheets
6:32 Return multiple items
7:29 Nest within other functions
8:58 Use multiple criteria
10:10 Match modes
11:59 Search modes
13:02 Nested XLOOKUP for grid view lookup
15:59 Wrap up
Watch related playlists
Playlist with all my videos on Excel: • ❎ How to use Excel
Connect with me on social
LinkedIn: / kevinstratvert
Twitter: / kevstrat
Facebook: / kevinstratvert101912218227818
TikTok: / kevinstratvert
Instagram: / kevinstratvert
Subscribe to my YouTube channel
https://www.youtube.com/user/kevlers?...
Want to watch again? Navigate back to my YouTube channel quickly
http://www.kevinstratvert.com
Support me with your Amazon purchases: https://amzn.to/3kCP2yz
⚖ As full disclosure, I use affiliate links above. Purchasing through these links gives me a small commission to support videos on this channel the price to you is the same.
#stratvert