Hi,

I'm not sure if this is the right sub-forum, but I have a problem. I have two different Excel files and I'm wondering if it is possible to find matching words or numbers in both Excel files.

For example

File 1:
ru*****re ruz***[email protected] 16-12-2016 21:24:02+00:00 45725 EU 71791 A***e Ru****a CA PAID_Betaalbewijs True
afri****tia1 t****[email protected] 12-12-2016 07:32:38+00:00 45806 EU 71097 Le**ia Pie***olas PF PAID_Betaalbewijs True


File 2:
20170101 J***a St****n 246 Name: J***a St****n Omschrijving: Bla bla bla 45725 IBAN: DE11**************8
20170101 A**a C***na 296 Name: A**a C***na Omschrijving: Bla bla bla 45806 IBAN: PL**********271

The bold numbers are matching. How can I build a program that does this automatically because I have about 40K rows in Excel.