ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

½Ð°Ý¦p¦ó§âÀx¦s®æªº¸ê®Æ®³¨Ó·í¤å¦r¥Î

½Ð°Ý¦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

¦^´_ 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)

TOP

·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

TOP

§Ú¦Û¤v¸Õ¥X¨Ó¤F
¥[¤@­Ó«ö¶s
¨Ã¥[¤W¤U¦C¤å¦r
Private Sub CommandButton1_Click()
Sheets("¤u§@ªí1").Range("d26").Value = Sheets("¤u§@ªí1").Range("d18")
End Sub
·d©w
ÁöµM¤èªk«Ü¤g
¦ý¬O¬O§Ú¦Û¤v·Q¥X¨Óªº
ÁÂÁÂtku0216¦^ÂÐ
jeason

TOP

        ÀR«ä¦Û¦b : ¦h°µ¦h±o¡C¤Ö°µ¦h¥¢¡C
ªð¦^¦Cªí ¤W¤@¥DÃD