• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search from Narration

Shabbo

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

Attachments

  • Lookup from Narration.xlsx
    9.7 KB · Views: 17
H2, array-entered (use Ctrl+Shift+Enter to commit the formula to the sheet, not just Enter) and copy down:
Code:
=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)))))
 
H2, array-entered (use Ctrl+Shift+Enter to commit the formula to the sheet, not just Enter) and copy down:
Code:
=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.
 
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.
 
Back
Top