Compare two xls file and copy matched data in to new row in second sheet

[pop_rockstar]

Hi all,

I have a requirement where I have to read two different xls files and compare the data in case found any match I have to populate the matched data on the next column in the second sheet.

sheet 1 (xls1)
------------------------
|Text | Replacement |
------------------------
| field1| replacement1|
------------------------
| field2|replacement2 |
------------------------

sheet 2(xls2)
--------------------------------------
Id |Text | Result |
---------------------------------------
1 | field1 | replacement1|
---------------------------------------
2 | field2 |replacement2 |
---------------------------------------

 

[wideboydixon]

Cell C2 on Sheet 2 of Book 2:

=VLOOKUP(B2,'{folder}\[{filename}]Sheet1'!$A$2:$B$3,2)

e.g.

=VLOOKUP(B2,'C:\Users\pop_rockstar\Documents\[Book1.xlsx]Sheet1'!$A$2:$B$3,2)

WBD

 

[pop_rockstar]

Cell C2 on Sheet 2 of Book 2:

=VLOOKUP(B2,'{folder}\[{filename}]Sheet1'!$A$2:$B$3,2)

e.g.

=VLOOKUP(B2,'C:\Users\pop_rockstar\Documents\[Book1.xlsx]Sheet1'!$A$2:$B$3,2)

WBD

Thanks for your response but I have a requirement to do this using macro.