Ãö©ó¤j±¿nªºVlookup½wºC§ïµ½ªº¥i¯à?
- ©«¤l
- 214
- ¥DÃD
- 74
- ºëµØ
- 0
- ¿n¤À
- 296
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- hk
- µù¥U®É¶¡
- 2013-6-17
- ³Ì«áµn¿ý
- 2018-11-3
|
ABCD.rar (342.39 KB)
¦^´_ 1# jazzcarr
[d1:d65536]¥Î¦r¨åpºâ0.3¬í,¥Îvlookup¨ç¼Æpºâ5¬í,¥Îvlookup¨ç¼Æªº¦n³B¬O«O¯d¤½¦¡,cÄæÀH¶ñdÄæ°¨¤W±o¨ìµ²ªG |
|
lmh
|
|
|
|
|
- ©«¤l
- 214
- ¥DÃD
- 74
- ºëµØ
- 0
- ¿n¤À
- 296
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- hk
- µù¥U®É¶¡
- 2013-6-17
- ³Ì«áµn¿ý
- 2018-11-3
|
¦^´_ 8# jazzcarr
Set d = CreateObject("scripting.dictionary")''''''«Ø¥ß¦r¨åd(¤£¥Î¤Þ¥Î)
a = [A1].CurrentRegion.Resize(, 4)''''''''''''''''''§âÀx¦s®æ¸ê®Æ©ñ¶iÅܶqa(¸ê®Æ¥u¦³3Äæ,³]©w4Äæ,³Ì«áÄæ±N¦s©ñµ²ªG)
For i = 1 To UBound(a, 1)
d(a(i, 1)) = a(i, 2)''''''''''d(n§ä¬O°Ñ·Ó)=§ä¨ìªºµ²ªG'''''§â©Ò¦³°Ñ·Ó©Mµ²ªG³£¸Ë¶i¦r¨åd,¤@¤@¹ïÀ³
For i = 1 To UBound(a, 1)
a(i, 4) = d(a(i, 3))''''''²Ä4Äæ¬Oµ²ªG,²Ä4Äæ=d(²Ä¤TÄæ)
Next i
[d1].Resize(UBound(a, 1)) = WorksheetFunction.Index(a, 0, 4)'''''¥kÃä¬O²Ä4Äæ¥þ³¡¸ê®Æ.§â¥þ³¡¸ê®Æ¿é¤JDÄæ
MsgBox Format(Timer - pp, "0.0000")''''''Åã¥Üµ{¦¡°õ¦æ¯Ó®É¦h¤Ö¬í |
|
lmh
|
|
|
|
|