Ledger Name in front of Bank Narration

[dklakhani]

i have got two Sheets one is BS and another one is Ledger Name
BS has got narration from Bank.
Ledger Name has got Name of party from Books of accounts.
I want get result like ledger from books of accounts in front of Narration from Bank

 

[shili12]

paste =TEXTAFTER(BS!A3,"-",3,0) on cell D3 in LedgerName worksheet

 

[dklakhani]

not working required ledger name in BS Sheet

 

[shili12]

not working required ledger name in BS Sheet

=TRIM(TEXTAFTER(A3,"-",3,0)) paste in cell B3 and drag

 

[dklakhani]

result is #NAME? NO REFERENCE OF LEDGER NAME SHEET IN ABOVE FORMULA

 

[shili12]

Ok am using office 365, you must be using legacy excel.

 

[dklakhani]

yes using legacy but will chk in office 365 too

 

[dklakhani]

thnx it works in 365 , when name is same in both the , but have another query related to this see the file where partially resemble