I'm making a script that will write a two-dimensional array to an Excel spreadsheet. The script is meant to be called from within other scripts. An outer loop runs once for every row in the array ...

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