merging data sets

**alanfoltz** · 08-23-2015, 12:33 AM

Good evening. I have a data set of about 2500 entries. i have another with about 2400. I need to merge them together. My issue is that the smaller set is exactly the same data as the other, just shorter. Let me try explaining like this. I have 2500 customers. 2400 have been inspected this year. I need to put those inspection results on the 'master sheet' attached to the customer name of course. A copy/paste isnt possible because after 60 or 70 we skip one and they are not on correct row anymore.

Thanks in advance

**FDibbins** · 08-23-2015, 12:41 AM

Hi, welcome to the forum

perhaps try a vlookup() if you want to bring back specific data, or match() if you want to ID the row of the match, or even a countif()

upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.