Apply filters from table to Excel Power Query

I am looking to create an Excel Power Query to do the following:

  1. Add a new data column to my raw data based on filters from a different table

Table 1 - Raw Data Raw Data

Table 2 - Filter criteria for Table 1 Filter Criteria

Table 3 - Final result Final result

I have tried using the merge tables feature but it limits the filter to 1 column/criteria.