Check box selection - referring multiple sheets
I have multiple sheets(sheet1,sheet2,sheet3,sheet4,sheet5) with email id's and I want to cross check in one master sheet in one check box column, if the match found then it should check the checkbox.
can we use index match formula to refer multiple sheets?
I'm trying to delete the master sheet email address if any of the email address are deleted from any of the 5 sheets. please help me with the workaround and formula
Help Article Resources
Check out the Formula Handbook template!