I have 1st Column with Names and 2nd column with some values against it.Now I have third column which has Names also Names from some other excel sheet.
1. I want to match Column 1 and 3 for duplicates and show the duplicates in Column 4
2. Once Duplicate Matche found I want 2nd Column Value...