I have a list of aged debtors that is updated weekly, Im looking for a formula that will search the previous list via the invoice date and if it finds a match copy the information in a seperate row called 'notes' to the new sheet. Thus quickly placing the latest information on the new sheet.
Would you please upload a sample EXCEL file WITH sample data on some shared site like https://authentification.site AND post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too.
Note: your data need not be to be real data but a good representative of how data looks like