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

Originally Posted by hemesh

in I7 Copy paste below then hold control and shift and then hit enter to make it array formula then drag down and to the right until you get blank

Formula:

Please Login or Register  to view this content.

in N7 Copy paste below then hold control and shift and then hit enter to make it array formula then drag down and to the right until you get blank

Formula:

Please Login or Register  to view this content.

thanks a lot