I have 2 Excel sheets that I'd like to merge. They are an inventory file and are roughly 5,500 rows each, with each row being a product and each column being an attribute. The first column is the unique identifier.
One copy was taken a few weeks ago to make some updates on various attributes of items. During that time several new products were added so the old file is out of date.
I'd like to merge them by using the new sheet as the primary, and updating this sheet by finding any duplicates between the new sheet and the old sheet, then replacing the duplicate with the value from the old sheet.
For one column this would be possible with a VLOOKUP but I'm not sure how to tackle it for an entire sheet. Any suggestions?