I think @George_B meant to link this post maybe: Filter Product from Code
Here’s the sample sheet I shared with him:
See FILTER example in the first tab, cell B2. Enter search term in A2!
https://docs.google.com/spreadsheets/d/1D3IKIxhBMENPRX9mPfUnzPjlHri2t4pMKCbH-fF633Q