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

[µo°Ý] ®æ¦¡¤Æ±ø¥ó §PÂ_Àx¦s®æ¤º®e¬O§_Åܧó

[µo°Ý] ®æ¦¡¤Æ±ø¥ó §PÂ_Àx¦s®æ¤º®e¬O§_Åܧó

½Ð°Ý¦U¦ì¤j¤j

ªí³æ³]­p·Q§PÂ_Äæ¦ì¤º®e¬O§_Åܧó

¦ýÄæ¦ìªº¸ê®Æ¬O¥Ñ¤½¦¡±a¥X¨Óªº

¨Ò:
¥ÒªíªºA1Äæ¦ìªº­È¬Ovlookup ¤Aªí¦Ó¨Ó
°²³]vlookup¥X¨Ó¬O123
­Y¨Ï¥ÎªÌÅܧó¬°456´N·|¼Ð¬õ©³
¦ý¦pªG¨Ï¥ÎªÌ¤S¦Û¦æÅܧó¦¨123«h¦^´_¦¨¥Õ©³

½Ð°Ý¥Î®æ¦¡¤Æ±ø¥ó¸Ó¦p¦ó³]­p

¦A½Ð¦U¦ì¸Ñ´b

¤U¤è¬O²©öªº¹ê¨Ò
®æ¦¡¤Æ±ø¥ó§PÂ_¤½¦¡.zip (4.64 KB)

ÁÂÁÂ
¥Î¥\¨ì¥@¬É¥½¤é¨º¤@¤Ñ¡ã¡ã¡ã

¦^´_ 1# li_hsien


    ®æ¦¡¤Æ±ø¥ó2.gif

TOP

¦^´_ 2# joblyc017

·PÁÂjoblyc017
³Ìªñªº°ÝÃD³£¦³³Ò±z¸Ñ´b
¥Î¥\¨ì¥@¬É¥½¤é¨º¤@¤Ñ¡ã¡ã¡ã

TOP

¦^´_ 3# li_hsien

get.cell¨ç¼Æ§PÂ_¬O§_¬°¤½¦¡¨ú­È
    ®æ¦¡¤Æ±ø¥ó§PÂ_¤½¦¡.zip (5.33 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 4# Hsieh

·PÁª©¥D¦^ÂÐ

¤S¾Ç¨ì¤Fget.cellªº§@ªk

¦]¬°¤H­ûÅܧó«á¡A¤½¦¡´N¨S¿ìªk¦^´_¤F

©Ò¥H¨S¿ìªk³æ¿W¥Î¤½¦¡¨Ó¬Ý

¥Ø«e§Ú¥D­n¬O·Q­n§PÂ_Äæ¦ì­È
¬O§_¸òvlookup±a¥X¨Óªº¤@¼Ë

¨Ì¥Ø«e»Ý¨D¡A¤ñ¸û²Å¦Xjoblyc017ªº§@ªk


ÁÂÁª©¥D¤À¨É !
¥Î¥\¨ì¥@¬É¥½¤é¨º¤@¤Ñ¡ã¡ã¡ã

TOP

        ÀR«ä¦Û¦b : ¡i°±º¢¤£«e¡A²×µL©Ò±o¡j¤H³£°g©ó´M§ä©_ÂÝ¡A¦]¦Ó°±º¢¤£«e¡FÁa¨Ï®É¶¡¦A¦h¡B¸ô¦Aªø¡A¤]¤FµL¥Î³B¡A²×µL©Ò±o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD