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

[µo°Ý] ½Ð°Ý¦p¦óÅý¨S¦³ªº¸ê®Æ¦Û°Ê·s¼W¨ì¥t¤@­Ó¤u§@ªí

[µo°Ý] ½Ð°Ý¦p¦óÅý¨S¦³ªº¸ê®Æ¦Û°Ê·s¼W¨ì¥t¤@­Ó¤u§@ªí

¥»©«³Ì«á¥Ñ a31075ha ©ó 2014-2-21 11:04 ½s¿è

¹Ï¤@¬O§Ú»s§@¥Î¨ìªº¥Í²£¤éªí


¹Ï¤@¬õ¦âªº³¡¤À´N¬OSheet2¨S¦³ªº¸ê®Æ

¹Ï¤G¬O§Ú¥t¤@­Ó¤u§@ªí Sheet2


§Æ±æ±N¹Ï¤@¬õ¦â³¡¤À¦Û°Ê·s¼W¨ì¤u§@ªísheet2 ¨Ã©¹¤U·s¼W¶ñ¤J¦UÄæ¦ì¸ê®Æ

¥H¤W¬O§Ú²¤Æ¹Lªºªí®æ ¤]¨Æ¹ê»Ú©Ò¦bªºÄæ¦ì
¦]¬°ªí®æ¤Ó¦hªF¦è©Ò¥Hª½±µÂ²¤Æ µe¥XVlookup©Ò¦bªºÄæ¦ì

¥Í²£¤éªí¬O§Ú¨C¤Ñ±Æµ{­n»s§@²£«~»Ý­nªºªí®æ
§Ú±N¨C­Ó²£«~¦W¨Ì·Ó²£«~½s¸¹±N¥LKEY¦bSheet2
¥D­n¬O¥Îvlookup¤½¦¡¥h¹ï·Ó²£«~½s¸¹±a¥X¨ä¥L¸ê®Æ
¦]¬°²£«~¶V¨Ó¶V¦h ²£«~½s¸¹¤]¶V¨Ó¶V¦h ªøªø»Ý­n¨ìsheet2¥h¬ö¿ý¸ê®Æ
¦ý¦]¬°ªøªø¤@¦£°_¨Ó´N§Ñ¤FKEY ¦Ó¥Í²£¤éªí´X¥G¥Î§¹´N§R°£¤F ³y¦¨ªøªø¦b°µ¦P¼Ëªº²£«~¤S¥²¶·¦b¥h§ä¸ê®Æ
¤£ª¾¹D¬O§_¦³¿ìªkÅý¥Í²£¤éªí¦bKEY¤J²£«~½s¸¹ªº¦P®É
¦pªGSheet2¨S¦³³oµ§²£«~½s¸¹¦Û°Ê©¹¤U·s¼W¤@µ§ ¨Ã±N¤Ø¤o¡B²£«~¦W¡Bªø«×¡B¼e«×¡B³t«×µ¥¶ñ¤J¹³¹Ï¤G³o¼Ë²£«~½s¸¹«áªºÄæ¦ì©O??
(¦Ó¦b·s¼W¸ê®Æ¶i¥hsheet2¤u§@ªí®É¤]¯à¸õ¥X´£¿ôµøµ¡¸ß°Ý§Ú¬O§_·s¼W©Î¨ú®ø)
¦]¬°¬Y¨Ç¬Û¦PªF¦è·|¥Î¤£¦P¤è¦¡´ú¸Õ¦ÓKEY¤Jªº¸Ü©È·|³y¦¨¸Ó²£«~½s¸¹»s§@¿ù»~ ¦Ó³o¼ËªF¦è¤j³¡¤À³£¬O¤ñ¸û¤Ö¼Æ¯S®íªº ©Ò¥H´N·|¤£§Æ±æKEY¤J


«ô°U¤j¤j ·PÁÂ

¦^´_ 1# a31075ha


    ¤j¤j ¦]¬°¤½¥q¨S¦³¿ìªk¥~±µºô¸ô¸ò½Æ»sÀÉ®× ³o¬O§Ú·Ó­ì¥»ÀÉ®×°µ¥X¨Óªº
©êºp ³y¦¨¤j¤j³Â·Ð ¦]¬°³Ìªñ±`¦³¤H¸ê®Æ¥Î¿ù ¦ÑÁó­n§Ú§ïµ½³øªíÅý³øªí§ó§Ö³t²³æ... = ="
¤@®É¤]¤£ª¾¹D«ç»ò¿ì??................

¥Í²£¤éªí¸Ì
  Vlookup ³£¬O¹ï·Ó¬õ¦âÄæ¦ì(²£«~½s¸¹)¥s¥X¬Û¹ïÀ³²LÂŦâÄæ¦ìªº¸ê®Æ
¦]¬°ªñ´Á¶V¨Ó¶V¦h·sªº²£«~½s¸¹ ¥D­n¬O§Æ±æ¤H­û¦b°µ·sªº²£«~½s¸¹
¤]¯à¤Ï¦Vªº§â¨S¦³ªº²£«~½s¸¹¸ò¬Û¹ïÀ³ªºÄæ¦ì¤Ï¹³¬ö¿ý¦^¥hsheet2¸Ì­±
¡°´N¹³¦C9µµ¦â¦rÅé Sheet2¸Ì¨S¦³¬Û¹ïÀ³ªº¸ê®Æ¤]¯à¦]¬°°µ¹L«á³Q¬ö¿ý¤W¥h

½d¨ÒÀÉ ½d¨Ò.rar (23.71 KB)

-------------------------------------------------------------------------------
¥t¥~¥H¤U¥i¦³¥iµL ¤£ª¾¹D¬O§_¯àÅý³øªíÅܦ¨¦Û°Êªº¨Ó­°§C¤H­û¶K¿ùªº¾÷²v
¡°´N¬O¥Í²£¤éªí¥k¤W¨¤ªº¥X³fªí³æ¤Ä¿ï µM«á®Ø¿ï­n¥X³fªí³æªº­q³æ½s¸¹«ö¥k¤W¨¤ªº¥X³fKEY IN
  ´N·|¦Û°Ê¶K¤J¦PÀɮפºªº¥X³fªí³æ¸Ì¬Û¹ïÀ³ªºÄæ¦ì
(¦]¬°¥X³fªí³æ¬O§¹¦¨«á­n¦C¦L¥X¨Ó ©Ò¥H¬O1¦¸20µ§¨Ã¨C¦¸¦C¦L³£·|§âªº²M°£)

¡°¦Ó®Ø¿ï¥k¤W¨¤ ²£«~¬ö¿ý ²§±`¬ö¿ý ´ú¸Õ¬ö¿ý ¤]¯à¦Û°Ê±N¸ÓÀɮפºªºÄæ¦ì¦Û°Ê´M§ä³Ì«á¤@µ§¤@ª½©¹¤U¶K¤W
(³o¤T­Óªí³æ¬O«ö¤ë¥÷¤@ª½¬ö¿ýªº ©Ò¥H·|¤@ª½©¹¤U¶K¤W ¤£ª¾¹D¬O§_¯à«ö®ÇÃ䪺¸ô®| ¸ò¤u§@ªí¦WºÙ «ö¨C­Ó¤ë¥÷§ó·sµ¹¥L·sªº¸ô®|¶Ü??)  


¤j¤j¦]¬°§Ú¥u·|¤@¨Ç¤½¦¡ VBA§¹¥þ¤£¦æ ¥u¯à¨Ó³o¸ò¤j¤j¨D±Ï¤F

TOP

        ÀR«ä¦Û¦b : «Î¼e¤£¦p¤ß¼e¡C
ªð¦^¦Cªí ¤W¤@¥DÃD