Comparing two excel spreadsheet lists

So I have this spreadsheet that has about 500 stores listed each in their own row with various information. I am currently making changes and adding to this list. My issue is that I am currently getting an updated list every few weeks with some stores being added and drooped from the previous. I would like to know if there was an easy way to compare the two lists and find out what changes have been made between the two (which stores have been added/dropped from the previous list). The reason I would like to do this is becuase I have been adding to the original list and would like to keep all of my updates to that list and just continue to build off of this.

If anyone has any good ideas on how I should manage these lists, please let me know!

As always thanks again in advanced for all the input and help.

-Greg

Thanks for the input.

My only concern is when the stores no longer line up with eachother.

When they sent me the new sheet it is sorted by store number.

So if a store is added that is not on the original list wouldn't the allignment be off and give me all false values?

If it could search for a specific store number through an entire colum and read true or false that would be much more helpful.

I would also need to know if the original spreadsheet has any stores that are no longer on the second spreadsheet.

Thanks