Needed data as per reason

[chiranjiv poojari]

Dear Team,

In my sheet there are three 1) Date 2)Reason for Pending 3)Original Current Status.

Needed status as per resolution file :

 

[Hany ali]

You must delete this post because it is a Duplicate and the post in this link has been replied
https://chandoo.org/forum/threads/needed-formula.43156/#post-257604

 

[chiranjiv poojari]

Dear hany,

It's not a duplicate one u can have a look

Earlier was different.

 

[chiranjiv poojari]

U can delete this post i have posted it in my old post .