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...
This is only available from the most up to date versions of Office 365. The new lookup function
= XLOOKUP( W*L, IF((width>=W)*(length>=L), width*length ), dimensions, , 1 )
is capable of identifying the next largest value (I have used an area) and returning both dimensions in a single lookup.