Join 300,000+ professionals in our courses: https://www.xelplus.com/courses/

What do you do when your Excel VLOOKUP isn't working? Or you need VLOOKUP to look to the left, but it doesn't work? Yes. Excel vlookup is the most used lookup function across the globe. With VLOOKUP you can get Excel to search for a certain value in a column and return a value from an adjacent column. You can use vlookup from another sheet or even from another file. It's a staple for most Excel users but it has its limitation. In this video I'll show you a newer lookup function (Excel XLOOKUP) that's much more powerful, flexible with less chances of making mistakes. XLOOKUP can look to the left and do vertical and horizontal lookups. Check out this episode of noob vs pro at the office.
Xlookup is currently available in Office 365 and Office 2021. Xlookup is not available in Excel 2016 or Excel 2019.

🌍 My Online Courses ► https://www.xelplus.com/courses/

00:00 How to Use VLOOKUP Function in Excel
02:31 Remove Duplicates
03:24 Why VLOOKUP Does Not Work
05:04 How to Use XLOOKUP Properly
06:02 Removing #NA Errors

👕☕ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/

🎬 LINKS to related videos:
Basics of Excel VLOOKUP: https://youtu.be/E7gQ-PgYkMc
How to Use the NEW & IMPROVED Excel XLOOKUP: https://youtu.be/4c0CLUER6nw

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

📚 Excel RESOURCES I Recommend: https://www.xelplus.com/resources/

🎥 GEAR I use: https://www.xelplus.com/resources/#gear

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

👉 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 #office365 #noobvspro