Data copy to another cell/sheet depending on multiple criteria

[Gaurav Tripathi]

Dear All,

Please give me formula to copy contents of a cell (Date in my case) depending on values on different cells of same row.

Please see the file attached for details. I need formula in green cells.

regards,

Gaurav

 

[Asheesh]

@Gaurav Tripathi ... see the attached...hope this helps

 

[Gaurav Tripathi]

Dear Asheesh,

Thanks a lot. It seems to be working perfectly. I uploaded a sample file. Now I will implement it in my actual sheet and check. If there is any problem, I will revert back.

Thanks again,

Regards