Excel formulas

Copper Contributor

Hi everyone :)


I have two different tables with different informations. 
on the first one are article numbers with total sold pieces.

in the other table are article numbers with their system information.

The two tables can have articles that are not in both tables.

how can I add to the first table the system information, so that every article number has the right system belonging information?


many thanks in advance



5 Replies
best response confirmed by Hans Vogelaar (MVP)

@Artangraz - Did you try with the Vlookup?




@SanthoshKunder Hi there! Thank you very much for your reply. how can I translate this in German?Could you give me the formula in german?.


many thanks in advance :)


Just in case, you may use this tool Translator • Excel-Translator to translate formulae.

I just turned my excel to English. Thanks very much
Thank you very much. This is eventually very helpful