For many, the INDEX-XMATCH combination in Excel is the go-to method for retrieving a value from a dataset. However, you can ...

Two-Variable Data Table Setting Up a Two-Variable Data Table: List one set of values horizontally and the other set vertically. Enter the formula above the vertical list of values.

This column shows how to use the Data Table option in Excel’s What-If Analysis tool.

Creating a list of duplicate values that’s separate from the data source is easier than ever thanks to Microsoft Excel's FILTER() function.