Hi, again, thank you for your help. With 27,000+ names to filter through, I'm dying to find a final solution.

I got the CTRL+Shift+Enter part (I didn't have the cursor in the formula bar).

The error that keeps occuring in my project, as well as my reconstruction of your simple dog-cat-train model, is the formula in Column B only refers to the adjacent cell in Column A. If cell B12 is selected, and the formula as written and confirmed is in the formula bar, when I click on Trace Precedents, it selects the $A$2:$A$31 with a blue bounding box, but a horizontal line goes from C12 to B12 and another one starting from A2 to B12. The second tracer is the same in all cells in Column B--they all have a tracer starting at A2 that points to selected cell in Column B.

Also, all cells in Column B with the formula in it have an "x" mark in Column B, even when the organization's name in Column C does not contain any of the filter words in Column A.

I tried to post a screenshot using Colo' HTML but got a bunch of garbage in the text. I can email you a screen shot if you would prefer.

If you can solve this, I'll send you a bag of the latest Starbuck's Black Apron coffee. This has turned out to be a bear. Thank you for your help.