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?