mystic_muffin
New Member
- Joined
- Apr 19, 2017
- Messages
- 17
Hey, Friends;
So lets say I have 4 box sizes with their dimension in a list. I also have an array of objects to fit in the boxes with their own dimensions. I only want to fit one item in one box so i want the box that fits the item the best. Under my "box that fits" column, I'd like a formula or something that can look down the item dimensions and compare them to the box dimensions and find whatever box works best with item, then display the name from column A. So if i have an item that 9x9x9 and a box that is 10x10x10, my sheet will choose that box because the item is just less than the box size.
[TABLE="class: grid, width: 800"]
<tbody>[TR]
[TD]box name[/TD]
[TD]box length[/TD]
[TD]box width[/TD]
[TD]box height[/TD]
[TD]item name[/TD]
[TD]item length[/TD]
[TD]item width[/TD]
[TD]item height[/TD]
[TD]box that fits[/TD]
[/TR]
[TR]
[TD]box one[/TD]
[TD]100[/TD]
[TD]68[/TD]
[TD]100[/TD]
[TD]1111[/TD]
[TD]90[/TD]
[TD]60[/TD]
[TD]88[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]box two[/TD]
[TD]110[/TD]
[TD]58[/TD]
[TD]43[/TD]
[TD]2222[/TD]
[TD]105[/TD]
[TD]50[/TD]
[TD]30[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]box three[/TD]
[TD]78[/TD]
[TD]43[/TD]
[TD]35[/TD]
[TD]3333[/TD]
[TD]20[/TD]
[TD]20[/TD]
[TD]10[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]box four[/TD]
[TD]48[/TD]
[TD]43[/TD]
[TD]36[/TD]
[TD]4444[/TD]
[TD]40[/TD]
[TD]60[/TD]
[TD]90[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Can anyone help me out with this?
I appreciate any assistance. Let me know if i need to clear anything up.
So lets say I have 4 box sizes with their dimension in a list. I also have an array of objects to fit in the boxes with their own dimensions. I only want to fit one item in one box so i want the box that fits the item the best. Under my "box that fits" column, I'd like a formula or something that can look down the item dimensions and compare them to the box dimensions and find whatever box works best with item, then display the name from column A. So if i have an item that 9x9x9 and a box that is 10x10x10, my sheet will choose that box because the item is just less than the box size.
[TABLE="class: grid, width: 800"]
<tbody>[TR]
[TD]box name[/TD]
[TD]box length[/TD]
[TD]box width[/TD]
[TD]box height[/TD]
[TD]item name[/TD]
[TD]item length[/TD]
[TD]item width[/TD]
[TD]item height[/TD]
[TD]box that fits[/TD]
[/TR]
[TR]
[TD]box one[/TD]
[TD]100[/TD]
[TD]68[/TD]
[TD]100[/TD]
[TD]1111[/TD]
[TD]90[/TD]
[TD]60[/TD]
[TD]88[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]box two[/TD]
[TD]110[/TD]
[TD]58[/TD]
[TD]43[/TD]
[TD]2222[/TD]
[TD]105[/TD]
[TD]50[/TD]
[TD]30[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]box three[/TD]
[TD]78[/TD]
[TD]43[/TD]
[TD]35[/TD]
[TD]3333[/TD]
[TD]20[/TD]
[TD]20[/TD]
[TD]10[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]box four[/TD]
[TD]48[/TD]
[TD]43[/TD]
[TD]36[/TD]
[TD]4444[/TD]
[TD]40[/TD]
[TD]60[/TD]
[TD]90[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Can anyone help me out with this?
I appreciate any assistance. Let me know if i need to clear anything up.