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 ...

VLOOKUP, one of the most useful Microsoft Excel functions, is also available on Google Sheets. Here's how to use VLOOKUP to sift through Sheets data.

After years of waiting, Google Sheets finally supports the powerful XLOOKUP function, and has added other powerful new functions too.

You can use VLOOKUP with Google Sheets similar to how the search function is used to find information in Excel.