Check a box if certain criteria are met

I want to check a box if a set of criteria exists in another table. This seems so simple, but I have no idea of how to build this formula. Here’s the example: