Hi guys, Welcome to the Advanced Video Search Engine, and you are watching XLOOKUP in Excel Tutorial. That video is uploaded by Kevin Stratvert at 2021-09-24T00:00:04-07:00. We are promoting this video only for entertainment and educational purpose only. So, I hope you like & enjoy it. [HXU7lsd0ftA]
| Name | XLOOKUP in Excel Tutorial |
| Video Uploader | Video From Kevin Stratvert |
| Upload Date | This Video Uploaded At 24-09-2021 07:00:04 |
| Video Discription | 🔥 Learn Excel in just 2 hours: https://kevinstratvert.thinkific.com In this step-by-step 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!AmxrofZZlZ-whM4IxMRV87IJqXHing?e=9xO0Z7 - How to use VLOOKUP in Excel - Complete Tutorial: https://youtu.be/DZEPA9UhLBw - Learn the fundamentals of Excel in just 2 hours: 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: https://youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY 🚩 Connect with me on social - LinkedIn: https://www.linkedin.com/in/kevinstratvert/ - Twitter: https://twitter.com/kevstrat - Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818 - TikTok: https://www.tiktok.com/@kevinstratvert - Instagram: https://www.instagram.com/kevinstratvert/ 🔔 Subscribe to my YouTube channel https://www.youtube.com/user/kevlers?sub_confirmation=1 🎬 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 HXU7lsd0ftA |
| Category | Science & Technology |
| Tags | kevin stratvert | xlookup | xlookup in excel | excel | excel xlookup | how to use xlookup in excel | stratvert | kevin | xlookup excel | xlookup tutorial | beginners | excel xlookup tutorial | two worksheets | spreadsheet | x look up | x lookup | how to use xlookup | excel xlookup tutorial for beginners | how to xlookup in excel | x look up in excel | how to do xlookup in excel | in excel | excel tutorial | function | formula | xlookups | xlookup formula | xlookup function | using xlookup | how to | how to use |
