For many, the INDEX-XMATCH combination in Excel is the go-to method for retrieving a value from a dataset. However, you can also use this dynamic duo to perform two-way lookups, returning a value at ...

How to Set Up a Totaling Spreadsheet in Excel. Understanding how cells behave in relation to one another is essential to getting the most out of Microsoft Excel. When you're working with multiple ...

Learn a seemingly tricky way to extract data from your Microsoft Excel spreadsheet.

XLOOKUP is Excel’s modern fix for everything VLOOKUP got wrong. It’s simpler, more flexible, and available in Excel 365 and ...

This month, Susan Harkins introduces an Excel user to advanced filtering and helps a PowerPoint user reduce his work when positioning pictures in PowerPoint.

How to Put Two Sets of Data on One Graph in Excel. One of the advantages of using Excel as your spreadsheet application is that you can display a simple piece of information just as effectively as ...

The MATCH function returns the position of a value (in a list, table, database). And, the INDEX-MATCH functions used together make extracting data from a table a breeze.