Don’t Use MATCH in Microsoft Excel: Use XMATCH Instead
Out with old, and in with the new!
There are many ways to extract values from data in Microsoft Excel, and two such examples are the MATCH and XMATCH functions. However, since Microsoft introduced XMATCH to Excel in 2021, I've ditched MATCH altogether, and in this guide, I'll explain why you should too.
