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.

A shared Microsoft 365 Lists list is more valuable if you can use it to update source data in Microsoft Excel.