Checkbox Formula

tkearney64301

Hello!

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.

Paul Newcome

So that I understand exactly what you are trying to accomplish...

 

Sheet 1 can have 10 rows with "xx123" in the ID column.

 

Sheet 2 has 1 row with "xx123" in the ID column.

 

You want to check the box on Sheet 2 when all rows on sheet 1 containing "xx123" have been checked.

.

Am I understanding correctly?