Working on a large Google Sheets document, the need has arisen to perform searches within it. However, the data has not been properly formatted and has been entered as a text string.
Is it possible to implement a “search engine” that allows searching by terms inside cells within a column?
For example, to be able to search for “French” and obtain as a result the rows 2, 5 and 10 of the example screenshot:
