½Ð°Ý¦p¦ó§âÀx¦s®æªº¸ê®Æ®³¨Ó·í¤å¦r¥Î
- ©«¤l
- 171
- ¥DÃD
- 33
- ºëµØ
- 0
- ¿n¤À
- 433
- ÂI¦W
- 298
- §@·~¨t²Î
- windows xp
- ³nÅ骩¥»
- sp3
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-6-8
- ³Ì«áµn¿ý
- 2024-11-5
|
½Ð°Ý¦p¦ó§âÀx¦s®æªº¸ê®Æ®³¨Ó·í¤å¦r¥Î
[attachimg]20410[/attachi
½Ð°ª¤âÀ°§Ú¸Ñµª¤@¤U
A1¨ìB122¬ODATA
F23¬O¨ç¼ÆVLOOKUP(D22,A1:B122,2,FALSE)¨Ó§@¬d¸ß
¥i¬O§Ú¤£·Q§âA1:B122¯d¦b¤u§@ªí¤¤
·Q¥Î°}¦C¤å¦r©ñ¤J¤½¦¡¤¤´À¥NVLOOKUP( )¨ç¼Æ¤¤ªºÈ
½Ð°Ý§Ú¦p¦ó§âD18ªºÈ½Æ¨î¶K¨ì¨ç¦¡´À¥NA1:B122ªºÈ
½Ð°ª¤âÌ«ü±Ð
ÁÂÁÂ |
-
-
¬¡¶Ã¯1.rar
(10.18 KB)
|
jeason
|
|
|
|
|
- ©«¤l
- 209
- ¥DÃD
- 43
- ºëµØ
- 0
- ¿n¤À
- 262
- ÂI¦W
- 0
- §@·~¨t²Î
- win 7
- ³nÅ骩¥»
- office 20**
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-11-3
- ³Ì«áµn¿ý
- 2017-4-16
|
¦^´_ 1# brabus
¥[¤J¤@Ó¤j¬A¸¹§Y¥i¡A¤½¦¡¦p¤U¡G
=VLOOKUP(D22,{10,186;11,189;12,192;13,195;14,198;15,201;16,204;17,207;18,211;19,215;110,221;111,225;112,229;113,233;114,237;115,241;116,247},2,FALSE) |
|
|
|
|
|
|
- ©«¤l
- 171
- ¥DÃD
- 33
- ºëµØ
- 0
- ¿n¤À
- 433
- ÂI¦W
- 298
- §@·~¨t²Î
- windows xp
- ³nÅ骩¥»
- sp3
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-6-8
- ³Ì«áµn¿ý
- 2024-11-5
|
·PÁ¦^ÂÐ
§Úªº·N«ä¬O¦p¦ó§â10,186;11,189;12,192;13,195;14,198;15,201;16,204;17,207;18,211;19,215;110,221;111,225;112,229;113,233;114,237;115,241;116,247
¤W±³o¨Ç¦r±qÀx¦s®æ¤¤,®³¥X¨Ó¶K¨ìvlookup( )¤¤¥Î©O?
¥Î½Æ¨î¬O®³¨ìD17&";"&A18&","&B18
¦Ó¤£¬O¥H¤W¨º¨Ç¼Æ¦r©O |
|
jeason
|
|
|
|
|