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

VLOOKUP¤¤#NA°ÝÃD½Ð±Ð

©Î³\¤j®a¤@ª½¨S¦³µo²{°ÝÃD¡A¦]¬°³o¦¸¸gÅç¤~µo²{¡A¦P¤@±i¤u§@ªí­Y»Ý­n³£­Ó²Ä1Äæ¡A«h³o­Ó²Ä1Äæ·|¥i¥H²¾°Êªº¡A¤]´N¬O»¡¡A¤£¥Î«Ø¥ß¦h­Ó¤u§@­¶¡AÁÂÁ¤j¤j­Ìªº´£ÂI¡A³o¼Ëªº¸ÑÄÀ¹ï§_¡H
§Æ±æ¤ä«ù!

TOP

=IF(C2="","",IFERROR(VLOOKUP(C2,¸ê®Æ!D,3,0),""))
­Yoffice¬°2003 ¨ç¼Æ¦p¦ó­×§ï
§Æ±æ¤ä«ù!

TOP

        ÀR«ä¦Û¦b : ¡i¦æµ½­n¤Î®É¡j¦æµ½­n¤Î®É¡A¥\¼w­n«ùÄò¡C¦p¿N¶}¤ô¤@¯ë¡A¥¼¿N¶}¤§«e¤d¸U¤£­n°±º¶¤õ­Ô¡A§_«h­«¨Ó´N¤Ó¶O¨Æ¤F¡C
ªð¦^¦Cªí ¤W¤@¥DÃD