Help in excel to calculate pallets.

Can someone please help me. I am struggling to figure this out.

I have on one tab, my inventory and product line.

Product line determines 40 or 80 bags per pallet.

Product line when 50 I call A

Product line for 80 I call B

Product line for 40 is C

Based on inventory available in column ‘B’ I want to calculate the number of pallets available in inventory using lookup to find the product line and either divide by 40 if it’s A or 80 if it’s B etc

Can someone please help me with this?

Can someone please help me. I am struggling to figure this out.

I have on one tab, my inventory and product line.

Product line determines 40 or 80 bags per pallet.

Product line when 50 I call A

Product line for 80 I call B

Product line for 40 is C

Based on inventory available in column ‘B’ I want to calculate the number of pallets available in inventory using lookup to find the product line and either divide by 40 if it’s A or 80 if it’s B etc

Can someone please help me with this?