Forum Discussion
Using IF formulas with Multiple Criteria
Hi I am trying to figure out which shipping box sizes I could use to ship products. I need each products dimension to fit into a specific box. Here is a sample of the box sizes Box # L W H ...
This might work for you:
=LET(box,$C$2:$C$6,L,$D$2:$D$6,W,$E$2:$E$6,H,$F$2:$F$6,filtered,FILTER(box,(I2<L)*(J2<W)*(K2<H)),IFERROR(MIN(filtered),"Bigger box needed"))