I am wondering if anyone can help me with a formula build. I have two sheets that have checkbox columns and unique codes. What I want to do is on one sheet, when all checkboxes are checked that have a unique code in the row to automatically check a checkbox with the same code on a different sheet.
The accounting team is checking off invoices that they book all at once together when an asset is live. After checking all the boxes that have a unique code (xx123) [there could be ten of them], I would like the one checkbox in the master sheet that has the same (xx123) code to check automatically.
It seems very simple in theory, but I am unsure if an IF formula or VLookup will work or if I have to use AND within a formula. I tried many different versions and can not seem to get this figured out.