The XMATCH function was introduced to Microsoft Excel in 2021 as an upgrade from the MATCH function. The default arguments in the XMATCH syntax are more intuitive than those in the MATCH syntax, ...

Excel spilled range operator (#) allows formulas to automatically adjust to changes in the spilled range size. You need to be using Excel for Microsoft 365 on Windows or Mac to make use of this handy ...