格式更改 轉換 (13247)

K3:L6=LOOKUP(1,0/($D3:$F3>0),OFFSET($D$2:$F$2,ROW(A1)*(B$2=$C$2),))

K10:L13=LOOKUP(1,0/(VLOOKUP($J10,$C:$F,{2,3,4},)>0),OFFSET($D$2:$F$2,(MATCH($J10,$C:$C,)-2)*(B$2=$C$2),))