Forum Discussion
Matching two excel files
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?
Check out the XLOOKUP function
Thanks for your answer but it doesn't seem helpful since I want to join the files automatically.