- ©«¤l
- 39
- ¥DÃD
- 8
- ºëµØ
- 0
- ¿n¤À
- 53
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- 2003
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2013-11-16
- ³Ì«áµn¿ý
- 2016-1-30
|
¦^´_ 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¸¹ ¥Dn¬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 |
|