CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formula
Tarik Hodzic
Tarik Hodzic

Reputation: 357

Arrayformula not filling column when using query and multiple importranges

Hey all I have the following formula but it isn't filling the rest of the column. It isn't even giving me an error when there is something else in a cell below it.

=arrayformula(IFERROR(QUERY(
{IMPORTRANGE("Sheet 1","Original!A:G");
IMPORTRANGE("Sheet 2","Original!A:G");
IMPORTRANGE("Sheet 3","Original!A:G");
IMPORTRANGE("SHeet 4","Original!A:G")}
,"Select Col7 where Col3='"&E4:E&"'",0), " "))

Does anyone have any idea why? If I don't use arrayformula and put the equation into each cell individually, it takes forever to load.

Upvotes: 0

Views: 146

Answers (1)

JPV
JPV

Reputation: 27242

Change your SELECT-clause to

"Select Col7 where Col3 matches'"&TEXTJOIN("|", 1, E4:E)&"'"

and see if that helps?

Upvotes: 1

Related Questions