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

Copper Contributor

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 and stock qtt

how can I now import the stock qtt from tab 2 in tab 1 based on the EAN

so: if EAN = 1234567891011 the stock should be .....

quess can be doe by formule


1 Reply


The attached suggestion used the INDEX and MATCH functions.