Join 400,000+ professionals in our courses here https://link.xelplus.com/ytdallcou...
Discover the power of Excel's XLOOKUP function in this beginnerfriendly tutorial. XLOOKUP simplifies data searching, making it an essential tool for efficient Excel use. Get ready to elevate your Excel skills with this easytounderstand guide.
⬇ DOWNLOAD the workbook here: https://pages.xelplus.com/xlookupexp...
No more VLOOKUP?! The NEW Excel XLOOKUP Function is here to stay!
Discover how XLOOKUP can solve your Excel lookup problems. Remember all those times your VLOOKUP wasn't working? You will have a better chance of getting your lookup formula correct on the first try.
What You'll Learn:
▪ XLOOKUP Basics: Understand the fundamentals of XLOOKUP including its primary arguments and how it outperforms traditional lookup functions.
▪ RealWorld Application: See how XLOOKUP can resolve common workplace challenges like identifying employee divisions and calculating bonuses.
▪ Advanced Usage: Learn how to use XLOOKUP for both vertical and horizontal lookups, and for finding the last match in a dataset.
▪ Versatility: Discover XLOOKUP's ability to work with unsorted data and its default exact match search, making it more flexible and powerful than VLOOKUP and HLOOKUP.
AVAILABILITY: XLOOKUP is available to Excel for Office 365 and Office 2021 users. If you'd like to learn about the other brand new Excel functions like FILTER, UNIQUE & SORT check out the complete course: https://www.xelplus.com/course/excel...
00:00 What is Excel XLOOKUP
00:55 XLOOKUP Basic Function
02:50 Get Last Match with XLOOKUP Search Mode
03:54 Get Next Smaller Match with XLOOKUP Match Mode
05:51 Why Excel XLOOKUP is Better than VLOOKUP
What is XLOOKUP?
If you need to lookup a value on another Excel sheet or table, you can use the XLOOKUP function. Here are some of its features:
XLOOKUP can lookup values to the left OR righthand side of the lookup range.
XLOOKUP looks for an exact match by default (you can change it if you like)
Use XLOOKUP to look for the next smallest value or the next largest value (approximate or close match)
XLOOKUP can do vertical AND horizontal lookups
XLOOKUP can find the first match or the last match (reverse lookup)
And guess what? XLOOKUP can also be combined with another XLOOKUP to lookup values inside a matrix which means XLOOKUP can replace INDEX & MATCH formulas too!
➡ Join this channel to get access to perks: / @leilagharani
Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/coursequiz/
RESOURCES I recommend: https://www.xelplus.com/resources/
Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#excel #XLOOKUP