In Search Field – Result(s) Always Show Specified Wanted

I would like certain rows to show, regardless of the search entry. For instance, enter “tires” and in-addition to all those rows with “tires” in them, these rows/vendors will show up in the results.

This requires quite a bit of custom coding to accomplish. It’s not something that’s possible with the built-in features.

I’m also not sure a Google Spreadsheet is the best tool for the job, here, but that’s another story.

In any event, I think you’ll need to write some code yourself or have someone else do it for you to accomplish that.