How to merge two tables into one?

Question

excel

There is one table with articles, title and price, and a second table with article, description, title and link to the picture. They need to be combined. The problem is that they are in different orders and match only by article and there are more positions in one table. How to make Excel compare articles and concatenate all fields

Answer 1

How to make Excel compare articles and concatenate all fields

Google "VLOOKUP excel"
(syntax, examples)

Answer 2

search keyword - consolidation

Answer 3

At the database level, it's easy.
JOIN statement