combine information from 2 tabs in 1 file based on common information (EAN)

I could not download the info needed in 1 file so I have downloaded 2 files.  i combined the 2 in 1 file 2 tabs. 1 file has amongst other info: EAN and article name. file 2 has among other, EAN an...