Data Comparison

I assume there is some reason you just don't use the new list like having a comment column or something like that.

In the attached workbook. The Blue table is the old list and the orange table is the new list.

The formula in Column C is =VLOOKUP([@[Old List]],Table_New,2,FALSE) which either gets the number for the new sale or returns #N/A. #N/A means that the store isn't on the new list. Filter for these and remove them.

Then copy column C and PasteValues into column B. You now have update all current records in the old table with the new sales data.

In the new table, the formula in columm H is: =ISNUMBER(MATCH([@[New List]],Table_Old[Old List],0)). This is true if the store is in the old table. It is false if the store is not on the old table. Filter for False and copy / paste into the old table.

The VLOOKUP is only going to find the first instance.

Attach a sample workbook so I can see what the data looks like and test out any solutions that I come up with. Include enough non-sensitive data to be representative of the kind of data you see.

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.