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?
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.Sign up to join this community
Yes, it's possible.
But first, bear in mind that
=CONCATENATE("a","b") is the same as
="a"&"b", but shorter.
=QUERY( IMPORTRANGE("key","A:Z"), "SELECT Col1, Col2, Col3 WHERE Col1 contains '"&B1&"' ORDER BY Col1" )
CONCATENATE - Docs editor help