How to create a search engine from text input, based on data from couple columns - google sheets

You can use the Does Contain list block to check if a list of values contains a particular item. Or you can use the “find first occurrence of” block to find out which row the search term is in. You really don’t need a loop at all.

You can see an example here:

Also see the Analyze List section of the documentation: