Best yield from table

Originally Posted by sleazyfish

Width does need to be taken into account simultaneously. Is this possible?

It already is (I tried to illustrate that by means of examples and outputs)

I take that back - the above was not an accurate solution... is the below better ?

I4:
=INDEX(F$4:F$7,MATCH(MIN(IF(($F$4:$F$7>=$C$4)*($G$4:$G$7>=$D$4),MOD($F$4:$F$7,$C$4)*$D$4+MOD($G$4:$G$7,$D$4)*INT($F$4:$F$7/$C$4))),MOD($F$4:$F$7,$C$4)*$D$4+MOD($G$4:$G$7,$D$4)*INT($F$4:$F$7/$C$4),0))
confirmed with CTRL + SHIFT + ENTER and copied to J4

So waste is determined by: waste height * width + waste width * complete units (as determined by height)

Example:

250/175 would return 1250/350 rather than 500/230 given the former leaves no waste whatsoever