Excel - Updating a datasheet with new data list

There are instructions at the top of the page explaining how to attach your sample workbook.

Originally Posted by JohnTopley

There are instructions at the top of the page explaining how to attach your sample workbook.

Thank you, I have uploaded the test file.

Hi JohnTopley!
Thank you so much for your reply.

I have made some corrections to the workbook as you have pointed out.

Basically what I am trying to do is, when I get daily updates, I am going to copy and paste them in Sheet2 so Sheet1 will get automatically updated. Sheet1 works as an updated database.

For the comparison and testing , I have updated
1) Sheet1 column C with INDEX($Sheet2.E$2:F$23,MATCH(A2,$Sheet2.E$2:E$23,0),2)
2) Sheet1 column D with =IFERROR(VLOOKUP($A2,Sheet2!$E$2:$F$27,2,FALSE),$B2) - This formula returns the same Old remarks for every row.

Analyzing the output of both formulas, I think i need a combination of the both to get what I need, if I ignore the part where I need to add the new entries into the database.

In Sheet2 in G2

=COUNTIF(Sheet1!$A$2:$A$19,E2)

in Sheet1 G4

=IF(ROWS($1:1)<=COUNTIF($A$2:$A$19,"> "),A2,IFERROR(INDEX(Sheet2!E$2:E$26,AGGREGATE(15,6,(ROW($E$2:$E$30)-1)/(Sheet2!$G$2:$G$26=0),ROWS($1:1)-COUNTIF($A$2:$A$19,"> "))),""))

Copy across and down

Need Excel 2010 or later