Range names are nice until you need to duplicate a tab, then you end up with a combination of local and global range names, where it isn't clear which is which. And god forbid you want to move a tab to another workbook, particularly if that workbook already has range names.
He does an INDEX/MATCH without specifying the match type to exact, which forces him to sort the lookup table. Specifying the match type should be muscle memory. And after 20 years of ignoring their users, the excel team finally introduced an xlookup fonction that does that. They also introduced other functions that are useful (and long overdue): SORT, UNIQUE, TEXTJOIN (somehow TEXTSPLIT only came several years later, I guess it was a hard computer science problem)
There are still functions that would be nice to have in Excel. An interpolate function that could take an X value, an X range and Y range, and an interpolation method (linear, polynomial, cubic splines, etc) and interpolate the value.