Ãö©ó¤j±¿nªºVlookup½wºC§ïµ½ªº¥i¯à?
- ©«¤l
- 26
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 84
- ÂI¦W
- 0
- §@·~¨t²Î
- win10
- ³nÅ骩¥»
- excel2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2016-6-10
- ³Ì«áµn¿ý
- 2018-8-20
|
Ãö©ó¤j±¿nªºVlookup½wºC§ïµ½ªº¥i¯à?
°²³]
A1~A65535 ©ñ°Ó«~¥N½X(^¼Æ²V¦X¦@¤Q¦ì¼Æ)
B1~B65535 ©ñ»ù®æ (¦ý»ù®æ¥i¯à¯Êº| ©Î ¥X²{¿ù»~È)
C1~C9999 ÀH¾÷©ñ¤J°Ó«~¥N½X(©Î«È¤H¦Û¦æ¿é¤J)
D1~D9999 Åã¥Ü¹ïÀ³CÄ檺°Ó«~»ù®æ
¥Ø«eªº§@ªk¬O±NA1~B65536©w¸q¬°¦WºÙ©w¸q"°Ó«~»ù®æªí"
¦A§âDÄæ¥ÎVlookupªº¤½¦¡°Ñ·ÓCÄæ¥h§ì»ù®æ
¦ý¦]¬°¸ê®Æ¶q¤jªºÃö«Y? ¤ñ¸û®z¤pªº¹q¸£·|¶]«Ü¤[
½Ð°Ý¦³§ó¦nªº¨ç¼Æ©Î¦Ûq¨ç¼Æ©Î°}¦C¨ç¼Æªº¼gªk¶Ü?
ÁÂÁÂ
¤S
ps.¤p§Ì¤£¬O¬ì¯Z¥X¥Í ¦³¤U±·Qªk ¤£ª¾¹D¹ï§_ ¦pªGÆ[©À¤£¹ï¤U¥i¯à·|¬Ý¤£À´½Ð©¿²¤ ©Î «ü¥¿ ·P®¦!
VBA¥i¥HÁקK«½Æ¤j¶qªº¹Bºâ¶Ü?¨Ò¦p¥ý§â¦WºÙ©w¸q"°Ó«~»ù®æªí"ªº¸ê®ÆŪ¨ì°O¾ÐÅ餺µ¥¤è¦¡?
¤£nÅýDÄæ¨C¤@®æVlookup³£¥h§ì¸ê¤@¦¸¦WºÙ©w¸q"°Ó«~»ù®æªí"ªº¸ê®Æ?
Åý¾ãÓDÄæ¨C¤@®æVlookup(©Î¦Ûq¨ç¼Æ)¦@¥Î°O¾ÐÅ餺ªº"°Ó«~»ù®æªí"ªº¸ê®Æ
ÂǦ¹ÅýVlookup(©Î¦Ûq¨ç¼Æ)¥i¥H§ó§Ö³t¹Bºâ?
ÁÂÁÂ |
|
|
|
|
|
|
- ©«¤l
- 26
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 84
- ÂI¦W
- 0
- §@·~¨t²Î
- win10
- ³nÅ骩¥»
- excel2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2016-6-10
- ³Ì«áµn¿ý
- 2018-8-20
|
¥»©«³Ì«á¥Ñ jazzcarr ©ó 2017-7-9 22:19 ½s¿è
¨ä¹ê¸ê®Æ¶q ÁÙ¶W¹L655536
»ù®æ¥i¯à¯Êº| ©Î ¥X²{¿ù»~Ȫº¤ñ²v¬ù0.1% (¦]¬°°Ó«~¥i¯à¤U¬[©Î¼È®É°±°â)
¦³¤ñvlookup§ó¦nªº¨ç¼Æ©ÎVBA¨ç¼Æ¶Ü? |
|
|
|
|
|
|
- ©«¤l
- 26
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 84
- ÂI¦W
- 0
- §@·~¨t²Î
- win10
- ³nÅ骩¥»
- excel2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2016-6-10
- ³Ì«áµn¿ý
- 2018-8-20
|
¦n³á ÁÂÁÂ
¥t¥~½Ð°Ý¥i¥H¼g¦¨°}¦C¤½¦¡¶Ü?
·|¤ñ¸û§Ö¶Ü? |
|
|
|
|
|
|
- ©«¤l
- 26
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 84
- ÂI¦W
- 0
- §@·~¨t²Î
- win10
- ³nÅ骩¥»
- excel2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2016-6-10
- ³Ì«áµn¿ý
- 2018-8-20
|
ÁÂÁ mhl9mhl9 ¤j¤j §Úªº¹q¸£¤ñ¸ûºC ¦ý¨âÓ¤èªkªº®É¶¡ ®t¤F±Nªñ20¿!!!
¥i¥H½Ð±zµù¸Ñ¤@¤Uµ{¦¡½X¶Ü?(¦r¨å¨ºÓ´N¥i¥H)
²Ä¤@¦¸¬Ý¨ì³o¼Ëªº¤è¦¡
¦ý§ÚÁÙ»Ýnµy§@קï
¤~¯à§@¬°¹ê°È¤Wªº¹B¥Î
·P®¦ |
|
|
|
|
|
|