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 '20 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 '20 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:

  • Welcome. Please remember that as per site guidelines when an answer addresses your question, you should accept it so others can benefit as well. May 28 '20 at 14:19
  • marikamitsos you are an absolute star, thank you.
    – Jackal
    Jun 1 '20 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. Jun 1 '20 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.