I wrote the Indexes of my notebooks in Google sheets to make them easy to find. But the Find function only looks for one word in the Google Sheets cell.
My notes look like this:
"Chemistry class notes of Sept. 14, 2021"
"Chemistry class notes of Sep. 15, 2021"
I want to find the index for Chemistry Class notes of Sept. 15, 2021 by typing:
- "chemistry sep 15"
How can I get it done?
Link to my spreadsheet
thx so much
This is the code I have written after watching some YouTube Videos (Google Sheets - Search, QUERY function by chicagocomputerclasses).
It works perfectly but it only searches in one column.
I want it to work in four or five columns.
I don't know how to modify this code to accomplish that.
=QUERY(AMF!A1:Z, "SELECT A WHERE 1=1 "&"AND LOWER (A) LIKE LOWER (""%" &JOIN("%"") AND LOWER (A) LIKE LOWER(""%", SPLIT(B1, " "))&"%"")",2)
I want to modify the code so it works in other columns besides Column "A"
Thx so much for your help in advance.