Compare two exel tables looking for identical values.

Hi Freelancers, I need help to ompare two exel tables looking for identical values. The rungs of two columns are texts and numbers, and among these are the ID codes (example: Xf86Gfs). I need the program to extrapolate these codes from the columns, compare them and return the result of the comparison, for example: Phase 1) The line A1-D (example) of excel contains the following text "Transfer with id: Xf86Gfs" Phase 2) After the program has extrapolated the code it compares it with the second excel sheet, looking for "Xf86Gfs". Phase 3) At the end of the comparison, the program must give me the result of the comparison: a) the compared rows that contain the identical code. b) the lines of sheet 1 that do not have identical values ​​in sheet 2 NOTE it is possible that in a row there are two values ​​to be extrapolated and compared, for example: The A1-D line of excel contains the following text "Transfer with id: Xf86Gfs on behalf number M45ssKL" in this case I want the program to extract two codes: "Xf86Gfs" and "M45ssKL" How does the program extract these codes? Or the programmer suggests it or by following the procedure below: 1) Select the first row of column X 2) Extrapolate the text in search of the words that precede the code to compare, so if the sentence contained in the line is "Transfer with id: Xf86Gfs on behalf number M45ssKL", then the program must look for the word "Transfer with id:" and then select the 7 words / number / symbols that follow 3) In this way the code "Xf86Gfs" will be processed 4) Repeat steps 1-2-3 for all lines. I wait for serious and interesting proposals for a long-term collaboration, thank you. Thanks Tarek