I found this formula:=QUERY(IMPORTRANGE(key,A:Z),SELECT Col1, Col2, Col3 WHERE Col1 contains 'value' ORDER BY Col1)Here and I'd like to add a concatenate function where 'value' is taken from cell (B1) for example. Is this possible? Any and all assistance would be much appreciated!
Concatenate inside ImportRange inside Query
google spreadsheets
Yes, it's possible.But first, bear in mind that =CONCATENATE(a,b) is the same as =a&b, but shorter.Example:  =QUERY(IMPORTRANGE(key,A:Z),SELECT Col1, Col2, Col3 WHERE Col1 contains '&B1&' ORDER BY Col1)ReferencesCONCATENATE - Docs editor help