Search from Narration

[Shabbo]

Dear Sir,
Can I apply excel formula to find value from bank narration (Bank Statement column C) to my bank ledger.

 

[p45cal]

H2, array-entered (use Ctrl+Shift+Enter to commit the formula to the sheet, not just Enter) and copy down:

=INDEX('Bank Statement'!G:G,(MIN(IF(ISNUMBER(SEARCH(LEFT(E2,LEN(E2)-2),'Bank Statement'!$C$2:$C$400)),ROW($C$2:$C$400)))))

 

[Shabbo]

H2, array-entered (use Ctrl+Shift+Enter to commit the formula to the sheet, not just Enter) and copy down:

=INDEX('Bank Statement'!G:G,(MIN(IF(ISNUMBER(SEARCH(LEFT(E2,LEN(E2)-2),'Bank Statement'!$C$2:$C$400)),ROW($C$2:$C$400)))))

What about another sheet.

 

[p45cal]

What about another sheet.

With such a brusque response I did a review of your past calls for help and noted that helping you is a thankless task, quite literally, and noted it: https://chandoo.org/forum/threads/data-summary-using-excel-formula.41874/post-249800 .
I won't embarrass you any further with my inadequate responses.

 

[Shabbo]

Dear Sir,
Regret for your inconvenience, I would say thanks thousand times for your help, I had liked your answer, because I was in travelling I just liked and ask about another sheet.