• 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.

Bank Reconciliation and Bank Ledger entry finding.

Shabbo

Member
Dear Sir,
I have bank statement and bank reconciliation, bank ledger has Vch No. which is available in bank statement either in reference number column or Description column.
I wanted to check entry and amount available in bank ledger.
Data is too large and it will take so long to reconcile can you please help me with a formula.
 

Attachments

  • excel help 3.xls
    47.5 KB · Views: 15
Use the formula given in your other thread to extract reference number.

Then use Index/Match or other lookup formula.
 
Use the formula given in your other thread to extract reference number.

Then use Index/Match or other lookup formula.
Sir,
Vlookup will not work because in some cases reference number is coming in ref colmn. like search from both column or any other formula.
 
Try...............

In "Bank Ledger" sheet "Bank statement" column J2, formula copied down :

=IFERROR(1/(1/LOOKUP(9.9E+307,SEARCH(G2,'BANK STATEMENT'!$C$13:$C$100),'BANK STATEMENT'!$H$13:$H$100)),"")

Regards
Bosco
 
Dear Sir,
Its not working because wherever there are blank showing 60000
Also its not giving a right result in sheet of BANK STATEMENT as well.

Please look into the same.
 

Attachments

  • excel help 12.10.2019.xls
    54.5 KB · Views: 12
Back
Top