How to link data to import from a sheet to another sheet in Google Sheets?

Question

Google Sheets

Greetings.
There are 2 sheets in Google Sheets. One, the base of goods, the second, in which an invoice is drawn up from the base of these goods.
In the sheet with the base of goods there is a "name" , "purchase price" , "price with an extra charge% ".
Through the "data check" I made a drop-down list by "name" from the database in the invoice preparation sheet (it became convenient to make a list).
The question is how to make a connection in the database or in the invoice sheet, "name" and "prices with a surcharge" , what would happen when choosing a "name"in the invoice preparation sheet, was the corresponding price of this product substituted in a certain cell of the same line? Now I have to manually copy-paste prices.

Answer 1

Use the VLOOKUP () function
You can use ARRAYFORMULA () to make a formula for the total column.