We are still celebrating the new XLOOKUP function released few hours ago.
The XLOOKUP is different from VLOOKUP in that it uses separate lookup and return arrays, it defaults to exact match and can extract from the Right or Left side of the Lookup column.
In a previous tutorial I showed you the basic functionality of the XLOOKUP function, Here is the link:
• VLOOKUP... Gone But No...
In this Video, I’ll show you how the XLOOKUP can return an array instead of a single value, or it can return Cell references for another function.
And then how can I nest multiple XLOOKUP functions to replace the classic Index and Match.
You can download the Exercise File and Follow along by clicking on the link:
www.amazon.ca/clouddrive/shar...
To read my blog articles you can visit:
www.See-How.ca (or www.OfficeInstructor.com)
To book a corporate training you can visit my website
www.OfficeInstructor.ca
I need a feedback from you about this tutorial and let me know in a comment which functionality you want to see in my future videos.
If you enjoyed this tutorial give it a Thumbs up and don’t forget to subscribe to this channel to be notified when new videos are posted: The Best Is Yet To Come.
Негізгі бет VLookup Fired...XLookup Hired - The New Giant Is Here
Пікірлер: 41