MATCHING two sets of data ranges

Hi All,

i wish to match a range of data (Table 1) against a specified criteria (Table 2). I tried the delete duplicates option in excel but to no avail.

Once matched I wish for the specific column to be deleted.

I have attached an Excel file for reference.