Query for Google's spreadsheet

Navigation
1

I'm doing a query for the google spreadsheet, but when in the where I indicated a cell of the sheet, I get an error.

The query I have is: 

=query(IMPORTRANGE("enlace"; "Llista!A6:S1000");"select * where Col6='"B1"' and 
Col8='"B2"'")

I have to say that cells B1 and B2 come from a data validation. Also, Col6 and Col8 may have to select everything and I do not know how to do it either.

    
asked by Iván Montero 19.12.2018 в 10:30
source

1 answer

1

I've only added & and it has worked =query(IMPORTRANGE("enlace"; "Llista!A6:S1000");"select * where Col6='"&B1&"' and Col8='"&B2&"'")

    
answered by 19.12.2018 в 13:06
WebView does not load with that page Help I have the following error in an activity that lists data in a ListView