Thread: [Solved] Compare sizes of different boxes and pick the correct size to put another box in to!
View Single Post
 
Old 01-11-2018, 06:05 AM
NBVC's Avatar
NBVC NBVC is offline Windows 10 Office 2013
The Formula Guy
  
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default
Try this formula:

It will find the first box with all dimensions equal to or larger than your specs.

=INDEX($A$2:$A$8,MATCH(1,INDEX(($B$2:$B$8>=F2)* ($C$2:$C$8>=G2)*($D$2:$D$8>=H2),0),0))

copied down

#N/A means no box can fit your specs.
Reply With Quote