IF formula, return data from another sheet in multiple cells

[Eskonn]

Here is an example of what I am trying to produce
In the Item # column (A,2) I want to type an item number in and have the description, size and total $ loss (Columns B, C, F) data auto populate using data from sheet 2.

Item #	Description	Size	Missing Case	Missing Bottle	Total $ Loss

Here is what the data looks like from sheet 2

Item #	Desc.	size	BTL Moving price	Btls/CS	Total $
65​	product 1	750.000 ML	7.82​	12​	93.84​
138​	product 2	750.000 ML	4.83​	12​	57.96​
139​	product 3	750.000 ML	16.98​	6​	101.88​
183​	product 4	750.000 ML	9.27​	12​	111.24​
283​	product 5	1.500 LT	7.17​	6​	43.02​
327​	product 6	750.000 ML	31.85​	12​	382.2​
328​	product 7	750.000 ML	27.08​	12​	324.96​
489​	product 8	1.500 LT	7.15​	6​	42.9​

 

[Sufiyan97]

Try

Sheet1

Book5
	A	B	C	D	E	F
1	Item #	Desc.	size	BTL Moving price	Btls/CS	Total $
2	65	product 1	750.000 ML	7.82	12	93.84
3	139	product 3	750.000 ML	16.98	6	101.88
4	283	product 5	1.500 LT	7.17	6	43.02
5
6
7
8
9
Sheet1

Cell Formulas
Range	Formula
B2:F4	B2	=INDEX(Sheet2!$B$2:$F$9,MATCH(Sheet1!$A2,Sheet2!$A$2:$A$9,0),MATCH(Sheet1!B$1,Sheet2!$B$1:$F$1,0))

Sheet2

Book5
	A	B	C	D	E	F	G
1	Item #	Desc.	size	BTL Moving price	Btls/CS	Total $
2	65	product 1	750.000 ML	7.82	12	93.84
3	138	product 2	750.000 ML	4.83	12	57.96
4	139	product 3	750.000 ML	16.98	6	101.88
5	183	product 4	750.000 ML	9.27	12	111.24
6	283	product 5	1.500 LT	7.17	6	43.02
7	327	product 6	750.000 ML	31.85	12	382.2
8	328	product 7	750.000 ML	27.08	12	324.96
9	489	product 8	1.500 LT	7.15	6	42.9
10
11
Sheet2

Note:

Headings should be same for both sheets