Connect with us

Sports

Discover What XLOOKUP Can Do For YOU (R.I.P. Excel VLOOKUP)

Published

1 year ago

on



🔥 400,000+ professionals trust our courses—start your journey here 👉 https://link.xelplus.com/yt-d-all-courses

Discover the power of Excel’s XLOOKUP function in this beginner-friendly tutorial. XLOOKUP simplifies data searching, making it an essential tool for efficient Excel use. Get ready to elevate your Excel skills with this easy-to-understand guide.

⬇️ DOWNLOAD the workbook here: https://pages.xelplus.com/xlookup-explained-file

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.
▪️ Real-World 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-dynamic-array-365-formulas/

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!

➡️ Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join

🎓 Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/

🎥 RESOURCES I recommend: https://www.xelplus.com/resources/

🚩Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
LinkedIn: https://www.linkedin.com/company/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

source

Related Topics:
Continue Reading
Click to comment

You must be logged in to post a comment Login

Leave a Reply

Sports

West Ham fans leaving before half-time against Arsenal 👀

Published

6 hours ago

on

November 11, 2026

By



SUBSCRIBE ► https://bit.ly/SubscribeSkySportsPL
PREMIER LEAGUE HIGHLIGHTS ► https://bit.ly/SkyPLHighlights2324
GET THIS SEASON’S PREMIER LEAGUE SHIRTS HERE ► https://bit.ly/SkySportsShop
West Ham fans pouring out of the London Stadium before half-time with Arsenal already 4-0 up! 😳#shorts

Watch Premier League LIVE on Sky Sports here ► http://bit.ly/WatchSkyPL
►TWITTER: https://twitter.com/skysportsPL
►FACEBOOK: http://www.facebook.com/skysportsfootball
►WEBSITE: http://www.skysports.com/football

MORE FROM SKY SPORTS ON YOUTUBE:
►SKY SPORTS PREMIER LEAGUE: https://bit.ly/SubscribeSkySportsPL
►SKY SPORTS FOOTBALL: https://bit.ly/SubscribeSkyFootball
►SKY SPORTS BOXING: http://bit.ly/SSBoxingSub
►SKY SPORTS CRICKET: http://bit.ly/SubscribeSkyCricket
►SOCCER AM: http://bit.ly/SoccerAMSub
►SKY SPORTS F1: http://bit.ly/SubscribeSkyF1
►SKY SPORTS: http://bit.ly/SkySportsSub
►SKY SPORTS GOLF: https://bit.ly/SubscribeSkySportsGolf

source

Continue Reading

Sports

Jamie Carragher & Jesse Marsch FULL Monday Night Football Post Match analysis! 📺

Published

8 hours ago

on

November 11, 2026

By



SUBSCRIBE ► https://bit.ly/SubscribeSkySportsPL
PREMIER LEAGUE HIGHLIGHTS ► https://bit.ly/SkyPLHighlights2324
GET THIS SEASON’S PREMIER LEAGUE SHIRTS HERE ► https://bit.ly/SkySportsShop
Watch the full post-match analysis from Monday Night Football after Everton and Crystal Palace shared the spoils under the Goodison Park lights. Jesse Marsch joins Jamie Carragher to delve deep into the tactical side of the game, reflecting on his time at Leeds and why it ended how it did.

00:00 – Everton points deduction
03:00 – Crystal Palace manager change
04:35 – Palace tactics for Ayew goal
06:11 – Did Glasner influence performance?
07:13 – Everton set-piece threat
11:58 – Jesse Marsch career reflection
15:07 – Marsch tactics and philosophy
19:24 – Marsch implementing Red Bull model in training
27:25 – Leeds tactics under Marsch
31:55 – First season at Leeds
33:24 – Leeds survival on the final day
34:31 – Leeds transfers under Marsch
36:04 – Marsch reflects on Leeds sacking
39:10 – Is Marsch’s style suited to the PL?
42:00 – Where next for Marsch?

Watch Premier League LIVE on Sky Sports here ► http://bit.ly/WatchSkyPL
►TWITTER: https://twitter.com/skysportsPL
►FACEBOOK: http://www.facebook.com/skysportsfootball
►WEBSITE: http://www.skysports.com/football

MORE FROM SKY SPORTS ON YOUTUBE:
►SKY SPORTS PREMIER LEAGUE: https://bit.ly/SubscribeSkySportsPL
►SKY SPORTS FOOTBALL: https://bit.ly/SubscribeSkyFootball
►SKY SPORTS BOXING: http://bit.ly/SSBoxingSub
►SKY SPORTS CRICKET: http://bit.ly/SubscribeSkyCricket
►SOCCER AM: http://bit.ly/SoccerAMSub
►SKY SPORTS F1: http://bit.ly/SubscribeSkyF1
►SKY SPORTS: http://bit.ly/SkySportsSub
►SKY SPORTS GOLF: https://bit.ly/SubscribeSkySportsGolf

source

Continue Reading

Sports

The reasons why Tottenham signed Radu Dragusin

Published

10 hours ago

on

November 10, 2026

By



SUBSCRIBE ► https://bit.ly/SubscribeSkySportsPL
PREMIER LEAGUE HIGHLIGHTS ► https://bit.ly/SkyPLHighlights2324
GET THIS SEASON’S PREMIER LEAGUE SHIRTS HERE ► https://bit.ly/SkySportsShop
Tottenham beat Bayern Munich in the race to sign Radu Dragusin. #shorts

Watch Premier League LIVE on Sky Sports here ► http://bit.ly/WatchSkyPL
►TWITTER: https://twitter.com/skysportsPL
►FACEBOOK: http://www.facebook.com/skysportsfootball
►WEBSITE: http://www.skysports.com/football

MORE FROM SKY SPORTS ON YOUTUBE:
►SKY SPORTS PREMIER LEAGUE: https://bit.ly/SubscribeSkySportsPL
►SKY SPORTS FOOTBALL: https://bit.ly/SubscribeSkyFootball
►SKY SPORTS BOXING: http://bit.ly/SSBoxingSub
►SKY SPORTS CRICKET: http://bit.ly/SubscribeSkyCricket
►SOCCER AM: http://bit.ly/SoccerAMSub
►SKY SPORTS F1: http://bit.ly/SubscribeSkyF1
►SKY SPORTS: http://bit.ly/SkySportsSub
►SKY SPORTS GOLF: https://bit.ly/SubscribeSkySportsGolf

source

Continue Reading

Sports

Carragher, Micah & Sturridge’s FULL Saturday Night Football Post Match analysis! 🔍

Published

11 hours ago

on

November 10, 2026

By



SUBSCRIBE ► https://bit.ly/SubscribeSkySportsPL
PREMIER LEAGUE HIGHLIGHTS ► https://bit.ly/SkyPLHighlights2324
GET THIS SEASON’S PREMIER LEAGUE SHIRTS HERE ► https://bit.ly/SkySportsShop
Jamie Carragher, Micah Richards and Daniel Sturridge dissect the thrilling 1-1 draw between Chelsea and Manchester City.

Watch Premier League LIVE on Sky Sports here ► http://bit.ly/WatchSkyPL
►TWITTER: https://twitter.com/skysportsPL
►FACEBOOK: http://www.facebook.com/skysportsfootball
►WEBSITE: http://www.skysports.com/football

MORE FROM SKY SPORTS ON YOUTUBE:
►SKY SPORTS PREMIER LEAGUE: https://bit.ly/SubscribeSkySportsPL
►SKY SPORTS FOOTBALL: https://bit.ly/SubscribeSkyFootball
►SKY SPORTS BOXING: http://bit.ly/SSBoxingSub
►SKY SPORTS CRICKET: http://bit.ly/SubscribeSkyCricket
►SOCCER AM: http://bit.ly/SoccerAMSub
►SKY SPORTS F1: http://bit.ly/SubscribeSkyF1
►SKY SPORTS: http://bit.ly/SkySportsSub
►SKY SPORTS GOLF: https://bit.ly/SubscribeSkySportsGolf

source

Continue Reading

Sports

The problems at Manchester United are to do with the ownership

Published

12 hours ago

on

November 10, 2026

By



► Subscribe to Sky Sports Premier League: https://bit.ly/SubscribeSkySportsPL
► Watch Sky Sports: https://bit.ly/BuySkySports

#shorts #manchesterunited #manutd

► Premier League highlights: https://bit.ly/PLHighlights2526
► MNF, FNF, SNF & Super Sunday analysis: https://bit.ly/SkyMatchAnalysis
► Gary Neville Podcast: https://bit.ly/GaryNevillePodcast
► Saturday Social: https://bit.ly/SkySaturdaySocial

► Buy this season’s shirts: https://bit.ly/SkySportsShop

More from Sky Sports on YouTube:

► Sky Sports: http://bit.ly/SkySportsSub
► Sky Sports Boxing: http://bit.ly/SSBoxingSub
► Sky Sports Cricket: http://bit.ly/SubscribeSkyCricket
► Sky Sports Darts: https://bit.ly/SubSkySportsDarts
► Sky Sports Football: http://bit.ly/SSFootballSub
► Sky Sports F1: http://bit.ly/SubscribeSkyF1
► Sky Sports Golf: https://bit.ly/SubscribeSkySportsGolf
► Sky Sports News: http://bit.ly/SkySportsNewsSub
► Sky Sports Retro: http://bit.ly/SkySportsRetroSub
► Sky Sports WSL: https://bit.ly/SubscribeSkySportsWSL

► Facebook: https://www.facebook.com/SkySportsFootball
► Instagram: https://www.instagram.com/skysportsfootball
► TikTok: https://www.tiktok.com/@skysportsfootball
► X: https://x.com/SkySportsPL
► Website: https://www.skysports.com

► To enquire about licensing Sky Sports content, you can find out more here: https://www.skysports.com/more-sports/news/31754/11434270/license-sky-sports-footage

source

Continue Reading

Trending

On this website we use first or third-party tools that store small files (cookie) on your device. Cookies are normally used to allow the site to run properly (technical cookies), to generate navigation usage reports (statistics cookies) and to suitable advertise our services/products (profiling cookies). We can directly use technical cookies, but you have the right to choose whether or not to enable statistical and profiling cookies. Enabling these cookies, you help us to offer you a better experience.