ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ·j´M§Ç¸¹¨Ã±a¥X»s¥O¸¹½X

¦^´_ 1# fantersy

¬O¥Î"°_©lBarcode"·j´M"¤u³æ¸¹½X"¶Ü??
D2=VLOOKUP(D1,IF({1,0},§Ç¸¹Á`ªí!K:K,§Ç¸¹Á`ªí!B:B),2,0)

TOP

        ÀR«ä¦Û¦b : ¦Y­W¤F­W¡B­WºÉ¤Ü¨Ó¡A¨ÉºÖ¤FºÖ¡BºÖºÉ´d¨Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD