Can you spot the error in the above formula?
It’s not about the new function of XLOOKUP. It’s about inevitable human error…
If you are an Excel fan, you should be aware of the exciting XLOOKUP function in Office 365. It is, no doubt, an awesome function that will beat VLOOKUP, HLOOKUP, LOOKUP, INDEX/MATCH in the future when it is generally available to all Excel users. You may find more details aboutfrom Microsoft Tech Community.
There are many very well presented videos about XLOOKUP on YouTube already. Just to name a few (my favorite YouTube channels),
So in this post, I am not going to talk about all the cool features of XLOOKUP. Instead, I would like to draw your attention to a potential mistake when writing XLOOKUP function.
You may download a Sample File to follow along.