Excel if cell contains partial text then return value from another cell

Excel if cell contains partial text then return value from another cell pictures 5