盤點倉庫數量 (13315)

I2=TRIM(MID(SUBSTITUTE(VLOOKUP($H2,$B:$F,2+(MOD(COLUMN(A1),2)=0)*3,),IF(MOD(COLUMN(A1),2),".","+"),REPT(" ",99)),INT(COLUMN(B1)/2)*99-98,99))



留言