In two-dimensional XLOOKUP formulas, it doesn't matter which way around the XLOOKUPs go. In this example, the ID lookup is first in the formula, and the column header lookup is nested. If these were ...

When the Format Cells dialog box opens, it's automatically set to display Excel's numeric-data format options. Select a format category that matches your data type.

Sparklines are small charts that fit into a single Microsoft Excel cell. But if you're tracking non-numeric data, they can exhibit weird behavior. Learn how to avoid problems when using sparklines.