訂貨從庫存列出明細 (11405)

 I3:I10=IFERROR(MIN(VLOOKUP(D3,A:B,2,)-SUMIF(D$2:D2,D3,I$2:I2),F3),0)

K3:N9 {=IFERROR(OFFSET($C$1,SMALL(IF($I$3:$I$10,ROW($2:$9)),ROW(A1)),CHOOSE(COLUMN(A1),1,2,6,5)),"")

格式化 A3:A6=SUMIF(D$15:D$21,A3,F$15:F$21)<B3