I’m trying to use the QUERY function in Google Sheets like this:
=QUERY(A2:I62854;"select I where G='"&C2&"' AND H='"&E2&"' ")
This query doesn’t work. I tried to manually input numbers like that:
=QUERY(A2:I62852;"select I where G=127 AND H=2123")
and it works. Am i doing something wrong ?
>Solution :
Remove the single quotes'(they are being considered as text strings) :
=QUERY(A2:I62854;"select I where G="&C2&" AND H="&E2&" ")