• 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

Chihiro

Excel Ninja
Use the formula given in your other thread to extract reference number.

Then use Index/Match or other lookup formula.
 

Shabbo

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

bosco_yip

Excel Ninja
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
 
Top