Hi Ajit,

Welcome to ExcelFox !!

You can accomplish by inserting the formula in F4 and copied down,

=IFERROR(IF(D4="C","Same Day Cancel",""),"")