Formula to return multiple values from LookUp function
We need a simple formula that can return all the values from data source based on a lookup. Vlookup, Xlookup return only first matching value and don't check further.
You can even use it and INDEX() in combination in a layered approach to give users PRECISE rights to see and/or edit a larger data set with row and column granularity.
A less complex version of that can be a terrific filter for data to be in a report, as well.
You can use FILTER() first, to make an actual table you can use further, or to make a virtual table in the formula that can be used further.
So for all the occurrences, just use FILTER() the first way, to make a table as your result set. You can combine with INDEX() to return ONLY the columns of interest, or by itself to get all columns, or just a contiguous range. That would be what you specifically ask for here.
Used within a function (well, the real table way too, just not in one step), you can then use functions like SORT() to order them differently for further processing, or LARGE() or SMALL() to get the "nth" one from either end, or a counting function to get how many rows exist and then pick one by number (though that's basically the same as SMALL() picking one n items from the start). You can even use those functions to get the top 10 or bottom 3 or what-have-you. Be an Olympic skating score provider and drop the highest and the lowest scores. Lots of variation here.
FILTER() is a wonderful new friend.