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.

[mubashir aziz]

Write this code in File Sub Cell D3

=INDEX('[main-file.xls]Sheet1'!$A:$A,MATCH(C3,'[main-file.xls]Sheet1'!$C:$C,0))

Don't forget to change S. Number in Main Sheet just like s. no. of Sheet Sub, its only a check that formula is working ...... u can check attach file for your guide line .....

[leeaw]

Hi there,

I need to compare the s/n between the main and sub. If the s/n matches, then i would require the Tag number from the main to be brought to the sub sheet.

Apologies for the confusion.

[leeaw]

hi there, thanks my problem was solved. Thanks for the time and effort. This formula works for my other work related problem. Appreciated!

[mubashir aziz]

Plz. always mark your thread solved after getting solution