QUERY syntax using cell reference March 6, 2023 by Tarik Copied from Web Applications: =QUERY(Responses!B1:I, "Select B where G contains '"&$B1&"'")