;abap debug inner table, then download, if use si tai, minus data must tranfer
=IF(RIGHT(G2,1)="-",VALUE(LEFT(G2,LEN(G2)-1))*-1,VALUE(G2))
;abap source code hikaku,
=TRIM(TEXT(A2,))=TRIM(TEXT(B2,))
;get benifit center 4 kai
=VLOOKUP(C2,Sheet2!A:J,10,FALSE)
;lookup result is null, transfer
=IF(ISNA(D2),C2,D2)
;lookup result is null, transfer
=IF(ISNA(VLOOKUP(C2,Sheet3!A52:B116,2,FALSE)),C2,VLOOKUP(C2,Sheet3!A52:B116,2,FALSE))
;lookup result is null, transfer
=IF(ISNA(VLOOKUP(D2,Sheet3!$A1:1:1:B50,1,FALSE)),"9999",VLOOKUP(D2,Sheet3!50,1,FALSE)),"9999",VLOOKUP(D2,Sheet3!50,1,FALSE)),"9999",VLOOKUP(D2,Sheet3!A1:1:1:B$50,1,FALSE))
=LEFT(C1,4)
=RIGHT(C1,LEN(C1)-4)
=" ,"&B1&" “&D1&” “&E1&” “&I1
=” ,"&TEXT(F1&G1&LENB(I1)-1,“00000000000”)&") TYPE C VALUE “&I1&”’"
=VALUE(“20”)