compare two sheets data and extract similar data to another sheets

sanju786

New member
Joined
Nov 16, 2021
Messages
1
Reaction score
0
Points
0
Excel Version(s)
2019
At attached worksheet here i want to compare to sheets and extract matched data to another sheets .i have data in sheet1 and sheet2 ,i need to compare two sheets data and if value on both sheets matched then it should appear on expected result(sheets) A5 and A6 and so on .please help to solve this problem i have attached sample sheets .
 

Attachments

  • sample_5 (2).xlsx
    11.9 KB · Views: 10
Back
Top