XLOOKUP in Excel - Tutorial for Beginners

Thanks! Share it with your friends!

You disliked this video. Thanks for the feedback!

Added 3 years ago by admin

116 Views

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.