Find Data and Merge to other Sheet

[leeaw]

Hi Guys,

I have few thousand line items which require me to find the same s/n under the main source and insert another data from main source which the sub file do not have.


I have attached the file for better understanding.

Main file is the source.
Sub file is my working file.

I would need to insert tag number from the main file to the sub file. The serial number is my reference.