FILTER, SORT, UNIQUE — modern array functions for Excel 365
FILTER pulls out matching rows from a table based on a condition. Unlike VLOOKUP (which returns one value), FILTER can return entire rows and multiple matches — all in one formula.