I want to import in a google sheet , the data of URLTab, only where Col 1 is equal to the column A of Tab2.
When I use the following formula, refering to only the first row of Tab2, it works fine.
=QUERY(Importrange("URL";"URLTab!A3:P");"select * where Col1 = '"&Tab2!A2& "'")
When I try to refer to the whole column A, it gives an error :
=QUERY(Importrange(""URL";"URLTab!A3:P");"select * where Col1 is not null and Col1 matches'"&JOIN("|", '"&Tab2!A2:A6& "'")"))
Could you please help me on the 2d formula ?
Thank you
>Solution :
You have some extraneous single and double quotes within the JOIN. At a guess, try this:
=QUERY(Importrange("URL";"URLTab!A3:P");"select * where Col1 is not null and Col1 matches '"&JOIN("|";Tab2!A2:A6)&"'")