Calulating box dimension for multiple items

[joanna101082]

Hello


Analysing pick up orders to calculate best shipping box to fit external lockers.

I have Orders details in in columns A-H so how many artilces are in the order, how many pieces, order volume and weight/
Columns F-H are the biggest dimensions (it could be one item or longest dimensions from different articles from the order)

In columns O-S you can see lockers dimensions


What formula would be the best to return best lockre size for the order to consider not only the biggest dimensions of the item but all order to fit (not only 1 item). Thank you for your help

[kvsrinivasamurthy]

Is it possible to give expected result and explain how it is calculated.