Forum Discussion
Finding the next largest material in both length and width
I am looking for a way to find the next size material based off any given width and length. I tried using index match to search for multiple criteria at the same time but could never get it to work h...
Thank you! SergeiBaklan
This was great! Instead of finding the "next size" that is less than the given value though I need to return the value that is the "next size" greater than or equal to the given width and length.
That will be practically the same, only change sign of criteria in AGGREGATE and in calculating the difference in sizes:
=INDEX(Material,MATCH(1,INDEX( --((Width-C2+Length-C3)=AGGREGATE(15,6,1/(Width>=C2)/(Length>=C3)*(Width-C2+Length-C3),1)),0),0))