Hi

I'm using this formula to list cells based on the presence of the word "clean" in another cell on the same row. It works fine, however I want it to filter the results even more by looking for another word in another cell on the same line, that word being "Composite Cladding" and the array of cells being 'PPM Schedule'!$G$2:$G$19999. I'm sure it's a simple fix, but I'm struggling!

This is the formula, I'd be grateful for any assistance!

Thanks

{=INDEX('PPM Schedule'!$B$2:$B$19999,SMALL(IF(ISNUMBER(SEARCH("*clean*",'PPM Schedule'!$K$2:$K$19999)),ROW('PPM Schedule'!$K$2:$K$19999)-MIN(ROW('PPM Schedule'!$K$2:$K$19999))+1,""),ROW(B2)))}