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 ...

Add this topic to your repo To associate your repository with the nested-fields topic, visit your repo's landing page and select "manage topics." Learn more ...