Numbers: checking if cell with specific text exists Prerequisites

I have some tables with cells like so:



Also, I have some more tables like so:





Objective

Note the YES and NO. in the Included column in the Example Requirements table.


You will note that for JAE 101 in the Example Requirements, a YES is to the right, because I have included it in the Example Semester table.
Conversely, there is a NO to the right of OME 321 because there is no such ID in the Example Semester.
Also, there is YAE 555 which has nothing to do with the Example Requirements table.




Problem

Unfortunately, the described scenario was a mockup; the YES and NO were placed manually by myself.

What formula do I put in the Included column of the Example Requirements table to reproduce such scenario?
This formula works where A3 is the cell which contains the search string and "Example Semester::A3:A4" is the range to search.

IF(IFERROR(MATCH(A3,Example Semester::A3:A4,0),FALSE),"YES","NO")