Comparing two excels based on row values and paste in another excel

Hi Team,

I want to compare two excels ,if the row values are same in two excels pick the value from related row(Count value) from excel 1 and paste in second excel(Value calculated)

Example as below:

Excel 1:

Count Code
6677 B522
1 T642
0 T656
2 T679

Excel 2:

Code Value calculated(Expected)
B522 6677
b549 0
B715 0
T679 2

Appreciate your help!

Like this, supposing you want to default all values not found in the first workbook to 0. (15,8 Ko)

1 Like

Thank you @Anthony_Humphries.

This works perfectly for my scenario.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.