Help with formula

[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

 

[Fluff]

Duplicate to: IF formula, return data from another sheet in multiple cells

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.