ªð¦^¦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 : ¯u¥¿ªº·R¤ß¡A¬O·ÓÅU¦n¦Û¤vªº³oÁû¤ß¡C
ªð¦^¦Cªí ¤W¤@¥DÃD