How-To Geek on MSN

Forget XLOOKUP: Why FILTER is better for extracting Excel data

The FILTER function extracts every matching record while XLOOKUP only returns the first result.