I have a sheet with a large array of data in it from which I want to QUERY data and match one column of that data to values in an array of cells
I have used various variations of the formula and only get matching data from W14, not the range W14:W
I have tried
your text
=ARRAYFORMULA(QUERY(UNFILTERED!A14:W, “SELECT A WHERE Q MATCHES ‘”&W14:W&”‘”))
your text
=(QUERY(UNFILTERED!A14:W, “SELECT A WHERE Q MATCHES ‘”&W14:W&”‘”)
your text
=(QUERY(UNFILTERED!A14:W, “SELECT A WHERE Q MATCHES ‘”&$W14:$W&”‘”)
Mark is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.