Excel formula needed to look up and copy data

[Closed]
Report
-
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
-
Hi,

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.

Regards,

Alex


1 reply

Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
118
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!