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

Posting a sample sheet with some data and manually mocked up results would be useful ( no pics please). Thx

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Hello, Here is a sample sheet of the problem I am attempting to solve. The formula is in cell A4. Row 22,23 and 24 each have a missing Color/Shape/Weight element. The problem is, if I conduct a search using just 1 or 2 of the 3 search elements and line 22,23 or 24 meet the criteria they do not get not show up in the results. Also, if row 21 meets the search criteria, the results for column D and E show zero rather than an empty cell. It would be nice to resolve this issue but it is not near as critical as at least the row is in the results. Thank you

IÂ’m not sure what is going on here. I log into my MSOffice Forum account and try and respond to my thread. I am again asked to sign in and I do. I try and attach sheet and again am asked to sign in to account which I do. I try and send attachment and asked am asked to sign in. The attachment never seems to get sent.

Keep trying!
In the meantime, I think you'll need to be adding the likes of
to your include element of the FILTER function.
Where exactly and whether you use multiply or add depends on which results you want to see.




For
you could use
although if there are errant spaces in those cells the liberal use of TRIM should help.




For you could wrap the whole formula in
All in all, quite convoluted.


Edit:
I note in your formula in msg#1 you have:
ISNUMBER(SEARCH (J2,R26:R500))
where there's a space between the H of SEARCH and the open parentheses. I hope it's the website's mangling of your formula because when I pasted the formula into a cell it didn't throw any error but the result was wrong.