How to get data from another google sheets?

Question

Google Sheets

There is a sheet with data:

1. Название	         Цена (1 шт/1кг)     К (100гр. 1шт)	Б	   Ж	         У
2. Куриная грудка	 1200	                 110	                23	   1,24        0

In the second sheet, I made a select (Function "Data Validation"), where you select the name of the product from the first sheet.
I need to load data on the price and KBJU of the product in the neighboring 5 cells.
How is it better to do this? Thanks

Answer 1

VLOOKUP function to help you (VLOOKUP in Russian)

Answer 2

A little advanced and with the MATCH () function I get the line number according to the value I need. And here's how to pull the data from the required columns further by row number - I'll never know. I myself see it like ='Products'!B'.'C3', but how to correctly combine the reference to the column and the row number in this execution? )
where
'Products'!B' is the desired sheet and the column in it
C3 is the cell with the value of the desired row, which I got via MATCH()