In short, the INDEX function extracts a value from a dataset, with the XMATCH function serving as the navigator to the correct row and/or column.

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

In this story, we’ll get you up and running with tables in Excel, from creating and formatting them to performing calculations on their data.