How to move data between two excel files

Good evening
I have a problem entering data into an excel file
I have two excel files and I want to search by ID. If I find match ID between files i want to write the location in the first file,

Hey @Waleed_Albariqi !! Welcome to the community!!!
Could you elaborate more on what you need? Which Input files? Do you want to write to spreadsheet or datatable? Do you look up the ID value in an entire column?

i used filter data in one file and i want to take some info by matching id between the two file

i want to take the location by using id and write it in the other file