流水編號 顯起訖號 (11999)

D3=VLOOKUP(B3,F:H,2,)&TEXT(VLOOKUP(B3,F:H,3,)+SUMIF(B$2:B2,B3,C$2:C2),"0000000")&"-"&VLOOKUP(B3,F:H,2,)&TEXT(VLOOKUP(B3,F:H,3,)+SUMIF(B$3:B3,B3,C$3:C3)-1,"0000000")