Import rows from another spreadsheet (containing multiple tabs) when column contains value
11:38 23 Aug 2016

What I have

This google spreadsheets containing multiple tabs. All the tabs have the same column layout.

What i need to do

Copy in a new spreadsheet all the rows from the spreadsheet when the column "3" contains a specific number.

What i've done

I've managed something like this:

={Query(importRange("URL"; "modulo!A2:O10"); "select * where (Col3=1)");Query(importRange("URL"; "modulo1!A2:O10"); "select * where (Col3=1)");Query(importRange("URL"; "modulo2!A2:O10"); "select * where (Col3=1)");Query(importRange("URL"; "modulo3!A2:O10"); "select * where (Col3=1)")}

It seems to work, but if the Column "3" doesn't contain the specific number in one or more tabs, the function give me the error: In ARRAY LITERAL, missing values in a literal expression of matrix to one or more lines.

How can i avoid this behavior? Is there a better code for solve my task?

import google-sheets match