Hello, I’m using this Filter Function.

=FILTER(F26:AD500,((ISNUMBER(SEARCH(G2,V26:V500))) +(ISNUMBER(SEARCH(G2,Y26:Y500))))*(ISNUMBER(SEARCH (J2,R26:R500)))*(ISNUMBER(SEARCH(M2,L26:L500))),"N o Results")



This works well as long as there is data in cell “V” or “Y” and cell “L” and cell “R”. The problem is I want to have rows selected where cell “V” and “Y” may not have data and/or cell “L” may not have data and/or cell “R” may not have data. Also, I don’t want any rows selected if all the search cells (G2,J2 and M2) are blank and where cell V,Y,L and R have no data. Thanks