how to find the common data from two excel files

reem369 

Depending on how much detail you're looking for, the solution may be as simple as a lookup formula or for a lot more detail something like Inquire's Compare Files feature.

Compare workbooks using Spreadsheet Inquire (microsoft.com)