Excel if text is found in range then return value

Excel if text is found in range then return value pictures 5