New to COUNTIFS
I'm using =SUMPRODUCT(COUNTIF(B18,"*"& FINDLIST &"*"))>0
To give me a simple true / false if an item in column B includes text defined in my named range findlist
Some of the items in findlist include "teak" "ash" "wood". (looking for commonly used wood materials)
Because data is non-standardized coming in, listing all variants would be onerous ("teakroot" "teak root" "FSCTeak" - I want to test true, but to anticipate and create all of these is a large job and could lead to errors).
So here's the rub: of course, on the flip side, there will be false trues, as far as my needs are concerned ("steak knife", "washers") will test true, and I will need to ignore these items for next steps.
I'm wondering if I can create a list of exclusions that can be developed as I find the common exceptions. If that could even be done (with countifs?), what would the result be, if there were items on both the include and exclude list (Example: "Rubberwood washers" would include two items from my find list "wood" "ash", and one from my excludelist "washers". Would this evaluate as true, as I would hope? And would "steel washer" evaluate to false, as the include / excludes would cancel out?
Thanks!
Bookmarks