Simple if statement

[MdYas]

Dear Expert,

Need help to get result as mentioned below,

[TABLE="width: 500"]
<tbody>[TR]
[TD]AWB No[/TD]
[TD]Remark[/TD]
[TD]Reason[/TD]
[/TR]
[TR]
[TD]12345678[/TD]
[TD]cash not ready[/TD]
[TD]here i want result[/TD]
[/TR]
</tbody>[/TABLE]

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

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



Regards,

Yaseen

 

[jtakw]

You're welcome.