Merging two worksheets and setting a migration date

So Sheet1 has 1000 rows and sheet2 has about 50 rows. You do a VLookup from Sheet1 to Sheet2. All the #N/A are the ones you need to copy over from Sheet1 to Sheet2. Is that the problem?

A possible similar problem to this was the MissingNumbers problem The User had a list of 10000 numbers but some were missing. He asked how he could find out which were missing. We created a list of all numbers and did a VLookup into the smaller List. Sort the list and the #N/A come to the top as missing. See attached.

Originally Posted by MarvinP

So Sheet1 has 1000 rows and sheet2 has about 50 rows. You do a VLookup from Sheet1 to Sheet2. All the #N/A are the ones you need to copy over from Sheet1 to Sheet2. Is that the problem?

A possible similar problem to this was the MissingNumbers problem The User had a list of 10000 numbers but some were missing. He asked how he could find out which were missing. We created a list of all numbers and did a VLookup into the smaller List. Sort the list and the #N/A come to the top as missing. See attached.

Thanks! I will take a look at it and see if I can apply this to my situation. I'll let you know the outcome, probably some time this afternoon.