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

 

[Tim_Excel_]

Not really clear what your question truly is, but I have an idea.

Try to use the IFS() function. This function allows many if statements without the need to put If statements inside other If statements.

IFS(A2="Tomorrow",B3="Spoken to Mr, as per Consignee want shipment delivery on dated. 20.08.2018 (customer not available)",A2="Residence closed",B3="Spoken to Mr, as per Consignee want shipment delivery on dated. 20.08.2018 (residence close)") and so on and so on.

 

[MdYas]

Thanks for your quick reply, please suggest how can i attached the file

 

[Tim_Excel_]

Try an online file hoster.

Have you tried my suggestion?

 

[Fluff]

Cross posted https://www.excelforum.com/excel-formulas-and-functions/1248626-need-formula-for-desire-result.html

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[MdYas]

Sir,

what i means is if i select "Tomorrow" from B2 column result be in column C2 Spoken to Mr, as per Consignee want shipment delivery on dated. 20.08.2018 (customer not available) or if i select "residence closed" so on[TABLE="class: cms_table, width: 268"]
<tbody>[TR]
[TD][/TD]
[TD][/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]
be so on

[TABLE="class: cms_table, width: 268"]
<tbody>[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]
please suggest how can i attach the sample file.

 

[Tim_Excel_]

I've already given you a possible solution.
Try to use the IFS function in the fashion of

IFS(A2="Tomorrow",B2="Spoken to Mr, as per Consignee want shipment delivery on dated. 20.08.2018 (customer not available)",A2="Residence closed",B2="Spoken to Mr, as per Consignee want shipment delivery on dated. 20.08.2018 (residence close)") <-- add further if statements

And try an online file hoster, like I already mentioned in my previous post.

 

[MdYas]

Dear Sir,

uploaded done.

 

[jtakw]

Hi,

There's no link to any uploaded file...

May be just a VLOOKUP:

Book1
	A	B	C
1	AWB No	Remark	Reason
2	12345678	cash not ready	Spoken to Mr, as per Consignee cash not ready want delivery on 20.08.2018
3
4
5	Tomorrow	Spoken to Mr, as per Consignee want shipment delivery on dated. 20.08.2018 (customer not available)
6	Residence closed	Spoken to Mr, as per Consignee want shipment delivery on dated. 20.08.2018 (residence close)
7	Cash not ready	Spoken to Mr, as per Consignee cash not ready want delivery on 20.08.2018
8	Not Respond	Try to Mr, call not respond, will next attempt 20.08.2018 (short address) SMS SEND
9	Unreachable	Try to Mr, call not reachable, will next attempt 20.08.2018 (customer not available) SMS SEND
10	Switchedoff	Try to Mr, call switch off, will next attempt 20.08.2018 (customer not available)SMS SEND
11	Self Collect	Spoken to Mr, as per Consignee he will self-collect from office
12	Double order	Spoken to Mr, as per Consignee want to cancelled shipment dueDOUBLE ORDER
13	RTO	Spoken toMr, as per Consignee want to cancelled shipment due CHANGE OF MIND
14	Cancelled	Spoken to Mr, as per Consignee want to cancelled shipment due DELAY IN DELIVERY
15	Out of station	Spoken to Mr, as per Consignee want shipment delivery on dated. 20.08.2018 (out off station)
16	Office closed	Spoken to Mr, as per Consignee want shipment delivery on dated 20.08.2018 (Office closed)
17	Misrout	Misrout within city
18	ODA	Spoken to Mr, as per Consignee shipment address is out of delivery area
19	Non attempt	Spoke to Mr, apologised and committed to next day delivery (NOT ATTEMPTED )
Sheet315

Cell Formulas
Range	Formula
C2	=VLOOKUP(B2,A5:B19,2,0)

 

[MdYas]

Thanks you so much its working perfectly