How to extract specific value and listed in new column with matching from original data.

Good evening,

In attachment I have 3 tables:
1. Table A: original Data
2. Table B: list of DIFFICULT APPROVAL BY COMPANY
3. Table C: list of Easy Rejected BY COMPANY

Q1:
In column K: list the difficult approval by company read from table A (column E) which more than 2, then according to values extract the correct code and company in both column I and J (table B) . then list the second one and so on by dynamic method.


Q2:
In column P: list the easy rejected by company read from table A (column F) which more than 1, then according to values extract the correct code and company in both column N and O (table C) . then list the second one and so on by dynamic method.




kindly see the excel sheet in attachment.

thank you very much