Lookup match index multiple values return other columns

try in J3, then drag-fill down:

=IFERROR(INDEX($F$3:$F$12,MATCH($H3&$I3&TRIM(LEFT($G3,FIND(" ",$G3)))&"*"&TRIM(MID($G3,FIND(" ",$G3&" ",FIND("/",SUBSTITUTE($G3&" "," ","/",2))),LEN($G3))),INDEX($D$3:$D$12&$E$3:$E$12&$A$3:$A$12&$B$3:$B$12&$C$3:$C$12,0),0)),"match not found")

another approach in J3 and drag-fill down:

=INDEX($F$3:$F$12,MATCH(TRUE,INDEX(ISNUMBER(SEARCH($A$3:$A$12&"*"&$B$3:$B$12&"*"&$C$3:$C$12&"*"&$D$3:$D$12&"*"&$E$3:$E$12,G3&H3&I3)),0),0))