Excel has allowed array formulas for literally decades. It’s not as complicated as the link you posted makes it seem. You just need:

1. A formula that supports array returns (like MMULT) 2. Know how big the returned array dimensions are 3. Highlight that array size, type in the formula, and press ctrl+shift+enter

Returning multiple matches from a single criteria isn’t what VLOOKUP was designed for, so rather than complain that a hammer does a bad job at screwing in nails, search for a screwdriver. Excel has tons of data filtering and table features, and allows DB connections for SQL queries.

Never knew of mmult. Will try to look at that technique to simplify the formula.

Aside from that, another user posted excel campus example of filter function. That also returns an array. And pretty much does what I need. However, it is only for office 365 insider and not to be released anytime soon.

Fot what I know, Microsoft is working on an improvement of arrays in excel: https://www.excelcampus.com/functions/dynamic-array-formulas...

Thanks for the link. I see filter function as helping me do the same thing as the link I posted.

Time to start crying. You can return an array. Just provide a 2D array to the return_array parameter.

From what I understand about xlookup, it will only return back the first value and not multiple values.

Or do a lookup over multiple columns without having to do some ugly concatanations