I'm new to this and I'm racking my brains over how to get this to work, I can do basic IF & Vlookup but I believe I need the merge the 2 for this one.

Is there a formula I can use on the "NLN" tab that will drag across all the data from the "R&MCollections" tab once the Tick-box on column P is True?

enter image description here

enter image description here

  • Welcome to Web Applications! We can't view your Sheet without requesting access, and I don't like giving out my email address to random strangers on the Internet :) – Glorfindel May 27 at 13:28
  • Hi Glorfindel I know it's not much but I've added 2 screenshots of the spreadsheet is that helps. – Jackal May 28 at 11:43

Please use the following query formula:

=QUERY('R&MCollections'!J1:Q," SELECT * WHERE P = TRUE ")

(you can change ranges to your needs)

Normally, when referring to text, the WHERE clause should be wrapped with single quotes ' '
But, when the clause depends on a Tick box, we MUST NOT use the single quotes.

As an example:
If one would look for John the WHERE clause should be WHERE P = 'John'

Functions used:

| improve this answer | |
  • Welcome. Please remember that as per site guidelines when an answer addresses your question, you should accept it so others can benefit as well. – marikamitsos May 28 at 14:19
  • marikamitsos you are an absolute star, thank you. – Jackal Jun 1 at 6:49
  • Thank you for taking the time to accept. Please remember that you can even upvote the answer. Your upvote will show up later, once you reach enough reputation points. – marikamitsos Jun 1 at 6:59

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.