Something like this: =IFERROR(IF(AND(FIND("W",[p code],5),FIND("1",[p code],5)),[price],""),"")
where [p code] is the reference to the product code cell(s) and [price] is a reference to the price cell(s)
but it is unclear if the "W" for White is the 5th character or after the 6th character. The 5 above assumes it is the 5th but would need to be 6 or 7 if the "W" for Wall oven is the 5th character as indicated in the image.
Also if the 5th character is color and the 6th character is voltage then you could simplify it to:
=IFERROR(IF(FIND("W1",[p code],5),[price],""),"")
