How to use the newish XLOOKUP() dynamic array function in Excel Your email has been sent Image: 200dgr/Shutterstock Must-read Windows coverage CrowdStrike Outage Disrupts Microsoft Systems ...

At the time of writing (April 2025), the SORTBY function ... However, by nesting SORTBY in this argument, you're telling Excel that the array is the table named T_Targets, but with the data ...