µù¥U
µn¿ý
º¶
½×¾Âª©³W
¸T¤î¦Cªí
»¡©ú
¦a¹Ï
¼Æ¦ì®Ñ»
¨p¤H®ø®§ (0)
¤½¦@®ø®§ (0)
½×¾Â¥ô°È (0)
¨t²Î®ø®§ (0)
¦n¤Í®ø®§ (0)
©«¤l®ø®§ (0)
³Â»¶®a±Ú°Q½×ª©ª©
»
Excelµ{¦¡°Ï
» ·Q½Ð°Ý¦³ÃöVlookup³t«×¤Wªº°ÝÃD
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
µo©«
[µo°Ý]
·Q½Ð°Ý¦³ÃöVlookup³t«×¤Wªº°ÝÃD
lucasyang123
µoµu®ø®§
¥[¬°¦n¤Í
lucasyang123
·í«eÂ÷½u
UID
22692
©«¤l
1
¥DÃD
1
ºëµØ
0
¿n¤À
3
ª÷¿ú
3
ÂI¦W
0
§@·~¨t²Î
Win7
³nÅ骩¥»
2010
¾\ŪÅv
10
¦b½u®É¶¡
0 ¤p®É
µù¥U®É¶¡
2015-11-17
³Ì«áµn¿ý
2015-11-23
¤p¾Ç¥Í
©«¤l
1
¥DÃD
1
ºëµØ
0
¿n¤À
3
ÂI¦W
0
§@·~¨t²Î
Win7
³nÅ骩¥»
2010
¾\ŪÅv
10
µù¥U®É¶¡
2015-11-17
³Ì«áµn¿ý
2015-11-23
1
#
¸õÂà¨ì
»
˧Ǭݩ«
¥´¦L
¦rÅé¤j¤p:
t
T
µoªí©ó 2015-11-17 20:54
|
¥u¬Ý¸Ó§@ªÌ
[µo°Ý]
·Q½Ð°Ý¦³ÃöVlookup³t«×¤Wªº°ÝÃD
Excel
,
Vlookup
,
VBA
¤U¸ü
(386.04 KB)
Data¨Ó·½
2015-11-17 20:49
¤U¸ü
(312.75 KB)
¬d§ä1
2015-11-17 20:49
¤U¸ü
(312.79 KB)
¬d§ä2
2015-11-17 20:49
¤U¸ü
(313.26 KB)
¬d§ä3
2015-11-17 20:49
·Q½Ð°Ý¤@¤UVBA°ª¤â¡A§Ú¥ÎVlookup¨ç¼Æ¥h§ä¬õ¦âÀx¦s®æ¡]¯Á¤Þ¡^¹ïÀ³ªº»ù®æ
¦ý¬O¦]¬°¸ê®Æ¦³¤Q´X¸Uµ§¡A¨C§ó§ï¤@¦¸¯Á¤Þ¤§«án¶]3¤ÀÄÁ¤~¯à¶]§¹©Ò¦³ªºVlookup
·Q½Ð°Ý¤@¤U¦³¨S¦³¿ìªk¥ÎVBA©Î¬O¨ä¥L¤èªkÅý³t«×ÅܧÖ
ÁÂÁÂ
¦¬ÂÃ
¤À¨É
ÀR«ä¦Û¦b :
¤H¥Í¤£¤@©w²y²y¬O¦n²y¡A¦ý¬O¦³¾ú½mªº±j¥´ªÌ¡AÀH®É³£¥i¥H´§´Î¡C
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
EXCEL±MÄÝ°Q½×°Ï
Excel£¸¯ë°Ï
Excelµ{¦¡°Ï
¶i¶¥À³¥Î±M°Ï
OFFICE ¨t¦C
Word
PowerPoint
Access
Office¤£¤À°Ï
µ{¦¡»y¨¥
VB »P VB.Net
C »P C#
Java »P J#
µ{¦¡³]p¤£¤À°Ï
¸ê®Æ®w
ORACLE
My SQL
MS SQL
ºô¶³]p
ASP »P ASP.NET
PHP
PHP+MySQL ¤Jªù¹ê§@
JavaScript
FLASH / ActionScript
HTM/ HTML/ CSS
ºô¶³]p¤£¤À°Ï
¹q¸£»P§@·~¨t²Î
¹q¸£¦UºØµwÅé°Q½×
¤@¯ë¹q¸£³nÅé°Q½×
½×¾Â¨Æ°È
ºÞ²z¤½§i
§ë¶D¤Ï¬M
·s¤â´ú¸Õ
·R ¡E ¥Í¬¡
¤½¯q§G§iÄæ
¥Í¬¡»P·P°Ê
[¦¬Âæ¹¥DÃD]
[Ãöª`¦¹¥DÃDªº·s¦^´_]
[³q¹L QQ¡BMSN ¤À¨Éµ¹ªB¤Í]
¥Ó½Ð¤Í±¡Ãì±µ
Facebook¯»µ·