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.
