Is there a way to combine a google sheets query with a join to filter by a list-CodePudding

Home > Mobile > Is there a way to combine a google sheets query with a join to filter by a list

Is there a way to combine a google sheets query with a join to filter by a list

Time：05-28

I have created the following formula

'=QUERY('Looker HVT'!A:AA,"select A,B,C,D where AA matches '" & join("' or A = '",Mapping!G:G) & "'",1)'

The formula runs okay and doesn't return any errors but it also doesn't return any results. The list in G:G matches the list in HVT AA:AA.

CodePudding user response：

The syntax is for instance

"select A,B,C,D where AA matches '"&textjoin("|",true,Mapping!G:G)&"' "