Multiple Values - One Lookup (with BYROW / FILTER)

Use the BYROW, FILTER and TEXTJOIN functions to create a way for a lookup to return multiple values - a constraint of the XLOOKUP function.
Introduces a LAMBDA function, XLOOKUPS, which converts the new function to a single function like XLOOKUP.

[@TheTramos00]

Good but just one detail: one of the advantages, among many, of using these powerful functions is not having to use auxiliary columns as they were used before with old school formulas. Here you are using F2# as an auxiliary column. It is better to obtain the result with a single formula in F2. =LET(u_brands;UNIQUE(B2:B26), brands;B2:B26, models;C2:C26, HSTACK(u_brands,BYROW(u_brands,LAMBDA(row,TEXTJOIN(", ",TRUE, FILTRAR(models;brands = row))))))