Excel gets a host of new features in January 2026 ...
The FILTER function extracts every matching record while XLOOKUP only returns the first result.