What is the formula for this operation?

Question

Google Sheets

How to make it so that at a certain value in one cell, its value is adjusted to another? For example. There is a warehouse. Each product has a name and article. If, for example, in the page with operations, select the article of the product from the drop-down line, its name should fit into the adjacent cells and into another price of this product. Is it possible in principle to do so?

Answer 1

Yesterday the same question was answered
https://qna.habr.com/q/1125504