Hi there,
I will be happy to help you with that. We can create a Google Apps Script web application with a nice HTML interface. The interface will have a search bar, in which you can enter a string, then hit a button. The frontend will run a backend G script function that will get all rows with a match and return the results to the interface.
Also, the search bar can be equipped with auto suggestion feature to suggest the product as soon as the user starts entering its name.
Examples of Google Apps Script web apps I have worked on:
[login to view URL]
[login to view URL]
[login to view URL]
[login to view URL]
I will be happy to address any of your questions!
Sincerely,
Mohamed