Transfer data beetween two tables

Hello,

I’m currently working on a project, which is suppost to show the sales results of different products by different categories.

In my first table I have the sales result of July of each article number but this table does not contain the different product categories.

In table 2 all available article numbers and the categories are listed. Column 2 in table 2 contains the article number, column 1 the category.

Right now I’m trying to find a formula which matches the article numbers and adds the category of the product numbers of table 2 in table 1. So for example in table 1 product number 123 is sold 55 times, number 124 40 times. Table 2 contains the information that number 123 is category A and 124 ist category B. These categories should be tranfered to table 1.

I hope you can help me with my issue.

Best regards, Mathias