Good day all,
I have this formula which works good to extract partial matches in range B1:B100
=INDEX($B$2:$B$19,AGGREGATE(15,6,(ROW($B$2:$B$19)-ROW($B$2)+1)/ISNUMBER(SEARCH($B$22,$B$2:$B$19)),ROW(A27)-ROW($A$26)))
This formula works well in extracting partial criteria (ISNUMBER/SEARCH) defined on B22 from data on Column B.
However, I'd like to include other criterias from Column C and D. Please refer to attached worksheet example. My formula can only assist me to get results A26:D36. However, I'd like to get results in A38:D40.
Thanks
Bookmarks