Hello,

I have a list of shipping boxes complete with their dimension. I also have a list of finished product packed in their own boxes! I have to chose which shipping box is the most sensible to use for each product - assuming one product per shipping box. It is easy enough choice to make manually - but I have LOTS to do and so want to know if Excel can make the decision for me! I've attached an example of the spreadsheet - I can organise columns by size and even chose max; min and median but I can't then figure out how to make Excel chose the right box! The products can be packed in any orientation.



Any help would be gratefully received!

Attached Files

Box problem.xlsx (8.8 KB, 230 views)