https://support.google.com/docs/thread/97413852/select-x-where-j-is-found-on-a-list-and-b-does-not-include-2-words-please-help?hl=en Feb 9, 2021 ... =QUERY('SCI & UF Orders'!A1:O,"SELECT A, B, C, D, E, F, G, H, I, J, K, L WHERE " & "J = '" & TEXTJOIN("' OR J ='",TRUE,V:V)&"'order by G",1).