Forum Discussion

Copper Contributor

Nov 21, 2023

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 https://www.youtube.com/watch?v=fDB1Ktyhp3Y&t=516s But I don't think I've got it q...

excel

Formulas and Functions

Harun24HR

Bronze Contributor

Nov 22, 2023

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))

filter.xlsx10 KB

Adam08780

Copper Contributor

Nov 22, 2023

Also tried https://www.xelplus.com/return-multiple-match-values-in-excel/
=IFERROR(INDEX(Data!$B:$B,AGGREGATE(15,3,((Data!$E:$E=Calcs!$E$1)*ROW(Data!$B:$B))-ROW(Data!$B$1),ROWS(Calcs!$H$1:H2))),"")
Which returns blank cell