ªð¦^¦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 : ¬Ý§O¤H¤£¶¶²´¡A¬O¦Û¤v­×¾i¤£°÷¡C
ªð¦^¦Cªí ¤W¤@¥DÃD