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

Match 2 spreadsheet up by invoice numbers and amounts

I

ITSDISP

New Member
I have 2 spreadsheets, one with our A/R on it which includes invoice number and amounts along with other items. The next spreadsheet is from our customer and shows invoices they are paying and amounts. Here they are


https://www.dropbox.com/sh/zj34k92pf9qvrvc/b1Xleww8eZ


Could someone please show me how to get the invoices numbers and amounts to match up. We have thousands of these to do.
 
Hi ITSDISP


Welcome to this forum.


Let me ask you one question.


Do you want to fetch the amounts(payed by the customer in "TM2 AGING.xlsx" workbook across all worksheets) with the invoice number you have in sheet1 of "1379367.xlsx" workbook?


Please clarify.


Regards,

Kaushik
 
You must log in or register to reply here.
Back
Top