I need a function to compare between two ranges and do a process on corresponding value

Hi all

I am using the Google Sheets
For each cell in the range (A7:F7), the following process should be done:
- compare the subjects which are listed in table A; the range (A6:F6) with subjects listed in table B; if the subject is identical then I need to compare the corresponding value in table A (cell A7) with the corresponding values in table B range (N8:Q8)

for example:
compare the content of cell C6 (Satellite Communications) in table A with subjects listed in table B (M8:M14), then I compare the corresponding value in cell C7 with the cell values (N10:Q10) if it is greater than 5% and less than 10% then the output is 5% and so on.

Thx.