B1:
=INDEX($E$2:$E$10,MATCH(TRUE,ISNUMBER(SEARCH($E$2:$E$10,A2)),0))
C2:
=INDEX($F$2:$F$10,MATCH(TRUE,ISNUMBER(SEARCH($E$2:$E$10,A2)),0))
=INDEX($E$2:$E$10,MATCH(TRUE,ISNUMBER(SEARCH($E$2:$E$10,A2)),0))
=INDEX($F$2:$F$10,MATCH(TRUE,ISNUMBER(SEARCH($E$2:$E$10,A2)),0))
=IF(COUNTIFS($G:$G,A3&B3)>=1,"Y","N")