Compare sizes of different boxes and pick the correct size to put another box in to!

		Microsoft Office Forums > Microsoft Excel > Excel
Compare sizes of different boxes and pick the correct size to put another box in to!

FAQ

Thread Tools

Display Modes

01-11-2018, 06:05 AM

NBVC

Windows 10 Compare sizes of different boxes and pick the correct size to put another box in to!

Office 2013

The Formula Guy

Join Date: Mar 2012

Location: Mississauga, CANADA

Posts: 215

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.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Word template: fixed size text boxes	apophis	Word	8	10-12-2015 01:48 AM
How to correct the different font sizes of bullets in Word 2007	Mac265	Word	4	01-23-2015 11:27 AM
Pick up Style tool (eye dropper)	ParreDL	Word	7	03-20-2012 06:40 AM
Font size in dialog boxes	nannycheryl	Word	0	07-10-2010 09:26 AM
Pick up data from Word documenta	jmarin	Excel	1	12-05-2008 02:31 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:49 PM.