You can use GridBase.searchRow method to provide a UI which progressively visits the grid row meeting the special condition.
Product name:
Product name: Customer name:
You can search in the data cell level and display the search results with using GridBase.searchCell.
Search 'Product name' fields.
Search term:
Search 'Product name' and 'Unit' fields.
Search term: