Learn how to use Excel’s INDEX and MATCH formulas to perform advanced lookups and data retrieval efficiently.

Since the XMATCH function is a modern upgrade from the MATCH function, it's only available to those using Excel for Microsoft 365, Excel for the web, the Excel mobile and tablet apps, and one-off ...

To pull data from another sheet in Excel, use cell references, use the VLOOKUP function, or use the INDEX and MATCH functions.

Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions.