display all row containing string from Both Dropdown list

Put this in F14

=IFERROR(INDEX(A$2:A$19,SMALL(IF(($F$8=$A$2:$A$19)*($G$8=$B$2:$B$19),ROW($A$2:$A$19)-ROW($A$2)+1,""),ROWS($A$2:A2))),"")

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

Copy across and down

Thanks John, i had figured it out, it was my silly typing mistake. thanks you so much for the Formula