I have a QUERY formula of Google sheets that works pretty much:
= query (data, "SELECT A WHERE B contains & # 39;" & A5 & "LIMIT 10", 1)
Essentially, the query does, for the given data range, it selects a cell in column A where column B contains some text, and I limit the output list of values returned to just 10 rows. Everything works well.
Where I encounter a problem, is when the "& A5 &" above refers to an empty cell, I always get a list of returned (and bad) values when really, if an empty cell is referenced, the output should be nothing at all. So, if "& A5 &" refers to an empty cell, I do not want ANY output value returned, that is, empty results.
I did a quick Google search on several different forums to find possible solutions. Apparently, "is not zero" could be a solution? Or <> & # 39; But I do not know how to integrate in the syntax.
My apologies, I am not an expert in sheets / queries / syntax and I would appreciate any advice / suggestions.