The FILTER function extracts every matching record while XLOOKUP only returns the first result.
Read about the role of an index number in economics and how index numbers can be applied to all kinds of data, such as ...
Make Excel evaluate your data for you.