Google Sheets: Query Question.

[p_s]

Is there a way to use the query function where your reference can have more than 1 possible value?

Example:

=QUERY(IMPORTDATA(https://website.com/mydatasetURL.csv),"SELECT A, B, C, D, E WHERE C = '"&PossibleReferences!A1:A50&"'",0)

Is there a way to do this without putting 50 OR statements in the query. And will this work with an external data set?

PossibleReferences!A1:A50 are text string values

Also, if we put it the dataset in the query will it still update automatically? Or do I need to keep refreshing that sheet?

 

[p_s]

So I found a solution that worked for me. But there is a limitation of 50000 characters in a join statement, and I have had 1600+ queries.

=QUERY(IMPORTDATA("https://MYURL.COM/sheet.csv"),"SELECT * WHERE Col1 = "&JOIN(" OR Col1 = ",FILTER(I:I,I:I>0)),1)