Fetching return reason until new record get fetched

[amit_gupta123]

Dear All


I have posted a sample file of which link is as under


http://www54.zippyshare.com/v/29885659/file.html


The sheet 1 contains the data and the sheet 2 contains the desired result. Actually aim is to repeat a invoice return reason for different invoices until the new return reason is not fetched up. would appreciate to get a solution via formula not vba code..thanks

 

[Faseeh]

Hi amit_gupta123,


The data is unorganized due to extra rows and i fear if any formula could fetch you reasons with data in this state. please organize it a bit first then you can locate the latest reason for any invoice.


Regards,