Premium Only Content

Discover What XLOOKUP Can Do For YOU (R.I.P. Excel VLOOKUP)
12 September 2019 Excel Lookup Formulas
Join 400,000+ professionals in our courses: https://www.xelplus.com/courses/
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.
★ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/
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://courses.xelplus.com/p/excel-dynamic-array-formulas
Timestamps:
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 right-hand 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!
⯆ DOWNLOAD the workbook here: https://www.xelplus.com/excel-xlookup-explained
► VLOOKUP tutorial: https://rumble.com/v2u8hqw
Playlist for Excel LOOKUP formulas: https://www.youtube.com/playlist?list=PLmHVyfmcRKyxpMnh_KKfAgp5DF9ydawmi
★ My Online Excel Courses ► https://www.xelplus.com/courses/
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
RESOURCES I Recommend: https://www.xelplus.com/resources/
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani
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!
#MsExcel #XLOOKUP #Excel #LeilaGharani
-
15:23
Mrgunsngear
10 hours ago $0.29 earnedSig Sauer Enclosed Sig Loc Romeo-X Compact Red Dot Torture Test & Review
2.07K2 -
LIVE
PandaSub2000
1 day agoLIVE 9pm ET | PICTIONARY & ANTICIPATION with Chat!
118 watching -
LIVE
megimu32
2 hours agoON THE SUBJECT: The Villains We Loved to Hate - Childhood Trauma Reloaded
120 watching -
LIVE
SpartakusLIVE
5 hours ago#1 Verdansk HERO || Live EARLY off EARLY
137 watching -
LIVE
Precision Rifle Network
1 day agoS4E21 Guns & Grub - New Optics and Chronographs
56 watching -
7:28:28
Dr Disrespect
10 hours ago🔴LIVE - DR DISRESPECT - WARZONE VERDANSK - EXTREME CHALLENGES
149K7 -
26:31
Glenn Greenwald
7 hours agoTrump at the NATO Summit: Michael Tracey Reports from The Hague | SYSTEM UPDATE #477
91.5K14 -
1:40:56
RiftTV/Slightly Offensive
6 hours agoSHOCKING: Pro-Israel Extremist CRUCIFIES Christian Pastor | The Rift
25.3K4 -
LIVE
The Breanna Morello Show
8 hours ago $1.74 earnedAutopen Scandal Gets Worse, Commie Take Over in NYC?, FBI Whistleblowers Need Help, Dividing MAGA- The Breanna Morello Show
255 watching -
14:23
World2Briggs
8 hours ago $0.30 earnedShocking Truth: Top 10 Most Racist Nations Revealed!
3.58K8