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

[µo°Ý] ¸ó¤u§@ªí¨ú¬Û¦P¦WºÙªº­È

[µo°Ý] ¸ó¤u§@ªí¨ú¬Û¦P¦WºÙªº­È

¦U¦ì¤j¤j&ª©¥D¦n

     ·Q½Ð±Ð¤@­Ó°ÝÃD,ªþ¥óA.xslx, B.xlsx, ¨ú¬Û¹ïÀ³ªº­Èvlookup¤½¦¡¥i¥H°µ¨ì,¦ý¦pªGÀÉ®×A ªº¤º®eMATA§ïÅܤF¦ì¸m¡A¦A¤£­×§ï¤½¦¡­n¦p¦ó¨ú­È©O???

  VBA¥i¥H¼g¥X¨Ó¶Ü???(©È¤j®a¤£À´ÀÉ®×B¬OÄæ¦ì¦WºÙ©T©wªº,ÀÉ®× A·|²¾¨Ó²¾¥h¦³¿ìªk¦bÀÉ®×B¤¤¨ú§ìÀÉ®×Aªº¹ïÀ³¸ê®Æ¶Ü????)ÁÂÁ ÀÉ®×.zip (11.31 KB)
yvonne

¦^´_ 1# afu9240


    ª©¤j¤È¦w¡A
    1.¥u­nvlookup¥i¥H°µ¨ì¡AVBA¤]¥i¥H°µ¨ì¡A¥u¬O±zªº½d¨ÒÀɤº®e¦³ÂI...¶§¬KXD
    2.«Øij½d¨ÒÀɤº®e¥i¥H°µ¤@­Ó§A·Q§e²{ªºµ²ªGµe­±¡A¦Ó¤£¬O¥u¦³BÀÉ®×[A1]Àx¦s®æ¼g¤@­Ó¤º®e¡AAÀɮק¹¥þªÅªº¨S¤º®e¡A
    Åý¤p§Ì¤£¤Ó¾å±o§A²Ó¸`­n¦p¦ó§e²{¡AÁÂÁ¡C

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¤Hªº§Ö¼Ö¡D¤£¬O¦]¬°¥L¾Ö¦³±o¦h¡A¦Ó¬O¦]¬°¥L­p¸û±o¤Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD