How to replace data from cells of one sheet with data from another by condition?

Question

excel

There are 2 sheets. Both sheets have 3 columns: article, price and discount. The articles are the same, only in the second sheet there are fewer of them and the values ​​​​of prices and discounts are different. I need, according to the values ​​​​of the articles in the second sheet, to replace the prices and discounts in the first. How can I do that? Or how can you delete the lines of the first sheet, where there are articles that are not in the second? I hope I explained clearly. Thanks in advance!

Answer 1

The VLOOKUP() function will help you.
=ВПР(A1;Лист2!$A$1:C3;2;ЛОЖЬ)more or less like this...