2

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?

2

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"
)

References
CONCATENATE - Docs editor help

  • Thank you so much! I thought it'd be a lot more convoluted... – Tim Niemeyer Jun 12 '15 at 21:01

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.