Matching two excel files

[amrmhmd]

Hi,

I have two excel files that share a same column. I want to copy the rows based on the identical values of that column.

Is there any way to match the rows?

[#2]

@amrmhmd 

Check out the XLOOKUP function 

[#3]

Thanks for your answer but it doesn't seem helpful since I want to join the files automatically.