=IFERROR(LOOKUP(2,1/COUNTIF($D2,"*"&MID($B$2:$B$8,9,FIND("-",$B$2:$B$8)-9)&"*"),C$2:C$8),"")
or try above formula inspired by "Sixthsense"