Simple if statement

[MdYas]

Dear Expert,

Need help to get result as mentioned below,

AWB No	Remark	Reason
12345678	cash not ready	here i want result

<tbody>
</tbody>

if i type or validate in column B3, want display result as per attached file in in column c

Tomorrow	Spoken to Mr, as per Consignee want shipment delivery on dated. 20.08.2018 (customer not available)
Residence closed	Spoken to Mr, as per Consignee want shipment delivery on dated. 20.08.2018 (residence close)
Cash not ready	Spoken to Mr, as per Consignee cash not ready want delivery on 20.08.2018
Not Respond	Try to Mr, call not respond, will next attempt 20.08.2018 (short address) SMS SEND
Unreachable	Try to Mr, call not reachable, will next attempt 20.08.2018 (customer not available) SMS SEND
Switchedoff	Try to Mr, call switch off, will next attempt 20.08.2018 (customer not available)SMS SEND
Self Collect	Spoken to Mr, as per Consignee he will self-collect from office
Double order	Spoken to Mr, as per Consignee want to cancelled shipment dueDOUBLE ORDER
RTO	Spoken toMr, as per Consignee want to cancelled shipment due CHANGE OF MIND
Cancelled	Spoken to Mr, as per Consignee want to cancelled shipment due DELAY IN DELIVERY
Out of station	Spoken to Mr, as per Consignee want shipment delivery on dated. 20.08.2018 (out off station)
Office closed	Spoken to Mr, as per Consignee want shipment delivery on dated 20.08.2018 (Office closed)
Misrout	Misrout within city
ODA	Spoken to Mr, as per Consignee shipment address is out of delivery area
Non attempt	Spoke to Mr, apologised and committed to next day delivery (NOT ATTEMPTED )

<colgroup><col><col></colgroup><tbody>
</tbody>

Regards,

Yaseen

 

[jtakw]

You're welcome.