HI!



I am using this formula to look for 1 criteria, but I was wondering If it can be made to look for more that one. I uploaded an example.
In the example I added the other criteria I want to look for


=IF(ISERROR(INDEX($A$1:$B$14,SMALL(IF($A$1:$A$14=$ E$1,ROW($A$1:$A$14)),ROW(1:1)),2)),"",INDEX($A$1:$ B$14,SMALL(IF($A$1:$A$14=$E$1,ROW($A$1:$A$14)),ROW (1:1)),2))

Thanks!

Attached Files

Copy of eImagine-Excel-Multiple-Matches.xlsx (16.4 KB, 27 views)