Creating classification column by matching multiple columns from other table

Dear Power BI community,

I am trying to classify rows in my dummy data based on 4 columns; country, area, subarea and name. 

I am trying to create a logic somehow like this:

- If in a row in the dummy data, the 4 columns match the same combination as in of the 4 columns in the lookup table --> take the classification from the lookup table.

- If the column values don't match, insert missing.

The lookup table can be interpreted like this:

- The 2nd row will result in all rows having country code 035, regardless of the other column values (since they are empty), will get the classification 'Pie'.

- 21st row will will result in all rows having country code 005 AND name AKKE will also get the classification 'Pie'.

I have no idea how to get this done in Power BI. Does anyone have a solution? Thanks in advance. The attached dummy data contains many rows, I hope that is not a problem.

Dummy data that needs to be classified:

https://drive.google.com/file/d/1qyysu-f5HktutCR372Nx8jS0EbnGNkSv/view

Classification/lookup table:

https://drive.google.com/file/d/1Mpb8-XnQY2kP8NkUhqs9pixV39Ee8tV7/view

Thanks in advance, again 🙂