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?

Solution 1:

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")