Excel if contains partial text vlookup

Excel if contains partial text vlookup pictures 5