How to link row to cell value in excle/google google spreadsheet?

Question

excel

In general, the task arose to make a database of goods with barcodes in the cloud, the implementation of ready-made programs is expensive and has a subscription fee, we decided to create it in a Google spreadsheet and here the problem arose of how to make it so that when entering a digital cell code (in our case, this is a barcode) in a new line immediately entered all the data of the whole line. For example, we recorded goods in a table where in cell A1 there is a barcode and in cells B1-K1, for example, the name, price, amount of balance, income, sale, etc.
how to link the cells so that when you enter the recorded barcode from a new line, for example, in A2 immediately data appeared in cells B2-K2 according to the barcode of the product.
Example - we have several barcodes recorded on Iphone 12, Samsung S20, Xiaomi 11 phones with prices, names, quantities and other information, in lines according to barcodes, as when entering only a barcode from the next line, the information of the whole line about a specific product appeared in the line - price, quantity, name, etc.?

Answer 1

VLOOKUP works perfectly here (barcode; table-with-data; column-number-with-data; 0)
If the action takes place in Google Spreadsheets, then you can do this:

ARRAYFORMULA(ЕСЛИОШИБКА(VLOOKUP(столбец-штрихкодов-по-которому-ищем;{столбец-штрихкодов-в-справочнике;данные-из-справочника};2;0);""))