quick question, please
I want to do a query import range formula in Google Sheets with three criteria:
1: E-mail
2: Number of the week (e.g: 2)
3: The data column
Ive already allowed the sheets to share information but I’m getting a "Query completed with an empty output." message, even thought the cell has an imput.
Formula: =QUERY(IMPORTRANGE("linkofthesheet";"Indicadores!A9:L123");" SELECT Col3 WHERE Col1 = ‘"&B4&"’ AND Col2 = ‘"&C10&"’")
I was trying before to use a vlookup together with it but a friend told me it would be redundant. Please, what do you guys think it could be the issue?
>Solution :
2: Number of the week (e.g: 2)
If cell C10 contains a number, you should leave the 'quotes' out, like this:
=query( importrange("...put sheet id here..."; "Indicadores!A9:L123"); "select Col3 where Col1 = '" & B4 & "' and Col2 = " & C10, 0)