Excel formula needed to look up and copy data

Closed
AlexA - Jun 22, 2011 at 06:06 AM
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 - Jun 22, 2011 at 06:40 AM
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 response

RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 120
Jun 22, 2011 at 06:40 AM
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
0