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

[µo°Ý] ¼Ð·Ç¤u®É¶}³æ¥ÎEXCEL

B2=IF(A2="","",VLOOKUP(A2,¼Ð·Ç¤u®É!B:B,2,0))
¦V¤U½Æ»s
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¤H¥Í¤£¤@©w²y²y¬O¦n²y¡A¦ý¬O¦³¾ú½mªº±j¥´ªÌ¡AÀH®É³£¥i¥H´§´Î¡C
ªð¦^¦Cªí ¤W¤@¥DÃD