Extract values in a range if conditions met

Looking for a formula to extract values in A2:A20 in Poducts Sheet if an option is selected in B1 dropdown option in Outcome sheet. B1 option is based on Region I and Region II values in D2:D20 and E2:E20 of Products sheet.

For example, if B1= East (Outcome sheet), extract values should be

Please Login or Register  to view this content.

Sample file attached

Put in A4 on Sheet Outcome and copied down until blanks results

=IFERROR(IFERROR(INDEX(Products!$A$2:$A$20;AGGREGATE(15;6;(ROW(Products!$D$2:$D$20)-MIN(ROW(Products!$D$2:$D$20))+1)/(Products!$D$2:$D$20=$B$1);ROW(A1)));INDEX(Products!$A$2:$A$20;AGGREGATE(15;6;(ROW(Products!$D$2:$D$20)-MIN(ROW(Products!$D$2:$D$20))+1)/(Products!$E$2:$E$20=$B$1);ROWS(A1:$A$1)-COUNTIF(Products!$D$2:$D$20;$B$1))));"")