Excel formulas

[Artangraz]

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

[#2 · Accepted solution]

@Artangraz - Did you try with the Vlookup?

[#3]

@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 :)

[#4]

@Artangraz 

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

[#5]

I just turned my excel to English. Thanks very much

[#6]

Thank you very much. This is eventually very helpful