Dear Sir,
I have got two Sheets one is Ledger Name and another one is BS.
BS has got narration from Bank.
Ledger Name has got Name of party from Books of accounts.
I want get result like Narration from BS in front of Party.
Eg : Party Name is UNIQUE SERVICE I want to get narration from Bank Contains Unique Service as example says.
I have highlighted yellow where the same report is expected.
these are the few example file is big please suggest a good formula.
I have got two Sheets one is Ledger Name and another one is BS.
BS has got narration from Bank.
Ledger Name has got Name of party from Books of accounts.
I want get result like Narration from BS in front of Party.
Eg : Party Name is UNIQUE SERVICE I want to get narration from Bank Contains Unique Service as example says.
I have highlighted yellow where the same report is expected.
these are the few example file is big please suggest a good formula.