Hi All
i have a sheet1 and sheet2 , i want to compare sheet2 with sheet1 and get the matching entries and put in sheet3
For example
Sheet1--i have columns A, B,C, D
1.JPG
Sheet2- i have column A
2.JPG
I want to compare Sheet2 Column A entries with Sheet1 Column C entries and get the matching entries and put it in sheet 3 as in below screenshot i.e user2 and user6 is matching though user1 is not matching but user 2 is matching in Row1, any matching entry
3.JPG
Bookmarks