Hi,
I have got a big file (1 million line), i send you here a part of it.
page 1 is a database of corporations, with clean names (without LTDA, S/A, etc)
page 2 is a database of corporations with their emails.
both lists do not correspond. 80% of corporations in page 2 are not present in page 1.
Corporations are identified by a ID number (cnpj) and a "clean name".
I need to know for which corporations in page 1 I have an email. So I try these 4 formulas to be sure to match them:
NB.IF(page2!C:C;page1!D2)
SEARCHV(D2;page2!C:D;2;FAUX)
NB.IF(page2!B:B;page1!A2)
SEARCHV(A2;page2!B:D;3;FAUX)
Of course, this works on 200 lines. Not on 1 million lines.
Can we do this with a macro ? I think it would permit me to match these bases and finally know for which corporations of page 1 i have an email. My final objective is to write the emails to them.
thank you very much
Bookmarks