Multiple word search

I've been battling with functionality of certain apps that make use of the search bar very frequently. A particular user has to be so selective with their search term (singular) order so as to basically perfectly match the values in the ref list sheet, often not being able to find relevant results at all.

Lets say we have a ref list that has a value of "John likes apples on a Thursday", and we make use of the search bar for this list by searching for "John Thursday", it doesn't bring up the result at all. Surely there is a simple feature change to include multiple search terms, out of any particular order, to produce results?

100% need this feature!

Status Open
1 0 74