Search an invoice number in a bank line

I wonder if someone can help.

As commonly knowing when looking at bank statements clients tend to put their invoice number or account as a ref. I then look the excel sale ledger and search for the invoice number. This is mainly done manually i.e copy the invoice number from the bank statement spreadsheet and Clt + f in the sale ledger which takes a long time to do.

I was wondering if there was a formula I can use that would autmotical find a common number between the two spreadsheet. the statements are made of column A-C and Would like the account number in D and the invoice number in E. in teh sale ledger spreadhseet the account is in the A column and the invoice in the B coloumn.

 

Thanks 

 

Abe

By: ABE H

Leave a Reply

Your email address will not be published. Required fields are marked *