How to combine two tables into one?

There is one table with the SKU, name and price and a second table with part number, description, title and link to the picture. They need to be combined. The problem is that they are in different orders and coincide only in the article and in the same table position more. How can make Excel compare articles and unites all the fields
March 19th 20 at 08:29
3 answers
March 19th 20 at 08:31
How can make Excel compare articles and unites all the fields

Googling "excel VLOOKUP"
(syntax, examples)
March 19th 20 at 08:33
the key word when searching - consolidation
March 19th 20 at 08:35
At the database level - easy.
Manual JOIN

Find more questions by tags Excel