I have QUERY formula
<code>=QUERY('My sheet'!J2:K;"SELECT J WHERE K="""&A1&"""")
</code>
<code>=QUERY('My sheet'!J2:K;"SELECT J WHERE K="""&A1&"""")
</code>
=QUERY('My sheet'!J2:K;"SELECT J WHERE K="""&A1&"""")
it works good if I have item without ” in A1 (for example table, my table, car )
but if i have item with ” my formula gets ERROR (for example “table”, my “table”, car is “black”)
How to modify this formula to make it work with ” simbols?
I try
{regexmatch(
=СИМВОЛ(39)&F4&СИМВОЛ(39)
and so on
New contributor
Heeg Ru is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.