Matching two excel files

New Contributor


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 Replies


Check out the XLOOKUP function 

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