Is it possible to create a formula that checks certain cells in a row against a lookup list and returns true/false value?

Here's a link to the spreadsheet for context. Essentially, here's what I'm trying to accomplish: In the tab titled 'Detailed Learning Report', I want column K to read "Complete" or "Incomplete" based on criteria. So, for example, for row 2, I want to check which site the UID is connected to and, depending on if it's Bedford, San Bernardino or Lithonia, determine if that user completed all required courses for that site. I have a breakdown of which courses are required per site on the tab titled 'Sheet 3'. Ultimately, at the end of this, I want a unique list of users (that's the unique list you see on the 'Sheet 3') and either "Complete" if all the required courses are marked completed in the 'Detailed Learning Report' tab or "Incomplete" if not. I'm not even sure if this is possible so I appreciate your help!