XLOOKUP, XMATCH, dynamic arrays and related functions. There are also new regex functions, but it seems that those didn’t make the cut for Excel 2024, unfortunately. I had situations in the past where lambdas would have been handy.