Formula to check a box if either of 2 boxes are checked in another sheet and criteria match

Kevin7859

I have a master contact sheet with various roles as columns, then a checkbox for removal of the role, but I want the individual role sheets to be able to see of either of the 2 roles are checked for removal and mark the contact in the role sheet as removed.

using this formula for checking one, but can't figure out the other

=INDEX({DCMR-SESIRRmvd}, MATCH(Email@row, {DCMR-Email}, 0))

Role sheet:

Master contact Sheet:

I have tried IF ORs as well as multiple Index Match but still can't figure it out.

Kevin7859

Found the solution: =IF(OR(INDEX({DCMR-SSSRmvd}, MATCH(Email@row, {DCMR-Email}, 0)), INDEX({DCMR-AltSSSRmvd}, MATCH(Email@row, {DCMR-Email}, 0))), 1, 0)

Kevin7859

Found the solution: =IF(OR(INDEX({DCMR-SSSRmvd}, MATCH(Email@row, {DCMR-Email}, 0)), INDEX({DCMR-AltSSSRmvd}, MATCH(Email@row, {DCMR-Email}, 0))), 1, 0)