Return value when part of a cell matches a word in a reference column

Put this in E2:

=IF(ISNUMBER(MATCH(TRIM(SUBSTITUTE(REPLACE(B2,FIND("-",B2),255,""),"POS W/D ",""))&"*",D:D,0)),C2,0)

then copy down. It works in your sample file.

Hope this helps.

Pete