Forum Discussion
Return Multiple Match Results
I'm trying to return multiple matches in the Calcs tab from the Data tab. Office 365. I've followed this tutorial Return Multiple Match Results in Excel (2 methods) - YouTube But I don't think I'v...
Adam08780 If you are on Microsoft-365 then could use FILTER() function.
=HSTACK(FILTER(E2:E7,E2:E7=H1),FILTER(B2:C7,E2:E7=H1))
Managed to get it to work with https://www.excelcampus.com/functions/return-multiple-values-with-the-filter-function/ . =FILTER(Data!B:B,Data!$E:$E=Calcs!$G$2,"")
