Dear Sir,

Great help. Thanks.

I was also able to derive outcome with the help of Vlookup with some manual work.

If there are hundred of entries, it becomes difficult as the required output for each account number needs to be copied down manually. Can you please help me in replicating the outcome for each account numbers in Raw Data.

May be some small macro or some other trick would help in this.

Thanks once again..

Kind Regards,

KB Manwatkar