So, to fix the random numbers you generated (I used the RAND function in my example below), select the cells containing those ...

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

To edit an array formula in Excel, click on the cell containing an array formula and then select the formula bar present at the top. You can now modify the formula as per your requirements.

Microsoft Excel's new dynamic array functions make complex calculations easier than ever before.

Use the RANDARRAY() dynamic array function to return random names or other text in Microsoft Excel.