ÎÊÌâÒÑ¿ªÆô (ÆÕͨÎÊÌâ)
VLOOKUP²Ù×÷Á÷³ÌË­»á£¿
ÌáÎÊÕß: ybx563822950  ÌáÎÊʱ¼ä: 2009-05-19    
 
  ÎÒÒª»Ø´ð£º
 

  ÇëÏÈ µÇ¼ »ò ×¢²á ÔٻشðÎÊÌâ

¸ü¶à Vlookup OOK ²Ù×÷ Á÷³Ì Ïà¹ØÎÊÌâ
ÎÊÌâ´ð°¸ ( 5 )

ºÃÏóÕâ¸öÎÊÌâÓ¦¸ÃÊÇÔÚEXCELÂÛ̳ÎÊ£¬±È½ÏºÃ!!_@s4fads1K:JFD()$#±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Àh$#$#&)K:JFD()$±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
VLOOKUP ewioK:JFD()$±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
($(ŶK:JFD±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
ÔÚ±í¸ñ»òÊýÖµÊý×éµÄÊ×ÁвéÕÒÖ¸¶¨µÄÊýÖµ£¬²¢ÓÉ´Ë·µ»Ø±í¸ñ»òÊý×鵱ǰÐÐÖÐÖ¸¶¨Á䦵ÄÊýÖµ¡£µ±±È½ÏֵλÓÚÊý¾Ý±íÊ×ÁÐʱ£¬¿ÉÒÔʹÓú¯Êý VLOOKUP ´úÌ溯Êý HLOOKUP¡£ @3221aK:JFD(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
re43289Î÷70K:JFD()$#_*±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
ÔÚ VLOOKUP ÖÐµÄ V ´ú±í´¹Ö±¡£
74*$#(*)K:JFD()$±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Óï·¨ 4f8e342ÊÇ4K:JFD()$#_±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
#(ô$K:JFD±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)
f12dsfK:JFD(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Lookup_value ΪÐèÒªÔÚÊý×éµÚÒ»ÁÐÖвéÕÒµÄÊýÖµ¡£Lookup_value ¿ÉÒÔΪÊýÖµ¡¢ÒýÓûòÎı¾×Ö·û´®¡£

Table_array ΪÐèÒªÔÚÆäÖвéÕÒÊý¾ÝµÄÊý¾Ý±í¡£¿ÉÒÔʹÓöÔÇøÓò»òÇøÓòÃû³ÆµÄÒýÓã¬ÀýÈçÊý¾Ý¿â»òÁÐ±í¡£ 3¶«oitreK:JFD()$±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ

Èç¹û range_lookup Ϊ TRUE£¬Ôò table_array µÄµÚÒ»ÁÐÖеÄÊýÖµ±ØÐë°´ÉýÐòÅÅÁУº¡­¡¢-2¡¢-1¡¢0¡¢1¡¢2¡¢¡­¡¢-Z¡¢FALSE¡¢TRUE£»·ñÔò£¬º¯Êý VLOOKUP ²»ÄÜ·µ»ØÕýÈ·µÄÊýÖµ¡£Èç¹û range_lookup Ϊ FALSE£¬table_array ²»±Ø½øÐÐÅÅÐò¡£ e342ÊÇ4K:JFD()±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
4fads13¶«oiK:JFD()$#_*±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
ͨ¹ýÔÚ¡°Êý¾Ý¡±²Ëµ¥Öеġ°ÅÅÐò¡±ÖÐÑ¡Ôñ¡°ÉýÐò¡±£¬¿É½«ÊýÖµ°´ÉýÐòÅÅÁС£ a21fd3s1fdÖK:JFD()$#_*±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
fd5a4K:JFD±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Table_array µÄµÚÒ»ÁÐÖеÄÊýÖµ¿ÉÒÔΪÎı¾¡¢Êý×Ö»òÂß¼­Öµ¡£ s²»21fds3aK:JFD()$#_±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ

Îı¾²»Çø·Ö´óСд¡£

Col_index_num Ϊ table_array Öдý·µ»ØµÄÆ¥ÅäÖµµÄÁÐÐòºÅ¡£Col_index_num Ϊ 1 ʱ£¬·µ»Ø table_array µÚÒ»ÁÐÖеÄÊýÖµ£»col_index_num Ϊ 2£¬·µ»Ø table_array µÚ¶þÁÐÖеÄÊýÖµ£¬ÒÔ´ËÀàÍÆ¡£Èç¹û col_index_num СÓÚ 1£¬º¯Êý VLOOKUP ·µ»Ø´íÎóÖµÖµ #VALUE!£»Èç¹û col_index_num ´óÓÚ table_array µÄÁÐÊý£¬º¯Êý VLOOKUP ·µ»Ø´íÎóÖµ #REF!¡£ @&%#*(ÎÒ)K:JFD()$#±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
jµÀh$#$#&)*(K:JFD()$#_*(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Range_lookup ΪһÂß¼­Öµ£¬Ö¸Ã÷º¯Êý VLOOKUP ·µ»ØʱÊǾ«È·Æ¥Å仹ÊǽüËÆÆ¥Åä¡£Èç¹ûΪ TRUE »òÊ¡ÂÔ£¬Ôò·µ»Ø½üËÆÆ¥ÅäÖµ£¬Ò²¾ÍÊÇ˵£¬Èç¹ûÕÒ²»µ½¾«È·Æ¥ÅäÖµ£¬Ôò·µ»ØСÓÚ lookup_value µÄ×î´óÊýÖµ£»Èç¹û range_value Ϊ FALSE£¬º¯Êý VLOOKUP ½«·µ»Ø¾«È·Æ¥ÅäÖµ¡£Èç¹ûÕÒ²»µ½£¬Ôò·µ»Ø´íÎóÖµ #N/A¡£ ewioK:JFD()$#_*(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
3289Î÷K:JFD(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
˵Ã÷ 12zcv545%#(ÃK:JFD()$#_*(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
erpoejµÀh$#$K:JFD()$#_*(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Èç¹ûº¯Êý VLOOKUP ÕÒ²»µ½ lookup_value£¬ÇÒ range_lookup Ϊ TRUE£¬ÔòʹÓÃСÓÚµÈÓÚ lookup_value µÄ×î´óÖµ¡£
Èç¹û lookup_value СÓÚ table_array µÚÒ»ÁÐÖеÄ×îСÊýÖµ£¬º¯Êý VLOOKUP ·µ»Ø´íÎóÖµ #N/A¡£ e43289ÎK:JFD()±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Èç¹ûº¯Êý VLOOKUP ÕÒ²»µ½ lookup_value ÇÒ range_lookup Ϊ FALSE£¬º¯Êý VLOOKUP ·µ»Ø´íÎóÖµ #N/A¡£ &%#*(ÎÒ)$#K:JFD()$#_±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
ʾÀý
$#$#&)*(K:JFD()$±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Èç¹ûÄú½«Ê¾Àý¸´ÖƵ½¿Õ°×¹¤×÷±íÖУ¬¿ÉÄÜ»á¸üÒ×ÓÚÀí½â¸ÃʾÀý¡£ 874*$#(K:JFD()±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
#$#&)*K:JFD(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
²Ù×÷·½·¨ dsfds1fadK:JFD()$#±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
321%$#(*$#ÊK:JFD()$#_*±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
´´½¨¿Õ°×¹¤×÷²¾»ò¹¤×÷±í¡£ *)#$@&%#*K:JFD()$#±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
ÇëÔÚ¡°°ïÖú¡±Ö÷ÌâÖÐѡȡʾÀý¡£²»ÒªÑ¡È¡ÐлòÁбêÌâ¡£ &)*(&#*($(ŶK:JFD()$#_*(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
vckjlurK:JFD()±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
4fads13¶«oK:JFD()$#_±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
´Ó°ïÖúÖÐѡȡʾÀý¡£ _@s4fadsK:JFD()$±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
sÒ²f12K:JFD(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
°´ Ctrl+C¡£
ÔÚ¹¤×÷±íÖУ¬Ñ¡Öе¥Ôª¸ñ A1£¬ÔÙ°´ Ctrl+V¡£
ÈôÒªÔڲ鿴½á¹ûºÍ²é¿´·µ»Ø½á¹ûµÄ¹«Ê½Ö®¼äÇл»£¬Çë°´ Ctrl+`£¨ÖØÒô·û£©£¬»òÔÚ¡°¹¤¾ß¡±²Ëµ¥ÉÏ£¬Ö¸Ïò¡°¹«Ê½ÉóºË¡±£¬ÔÙµ¥»÷¡°¹«Ê½ÉóºËģʽ¡±¡£ ($(Ŷ*&#%kcvK:JFD()$#_*(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
¸ÃʾÀýʹÓà 1 ¸ö´óÆøѹµÄ¿ÕÆøÖµ¡£ $#$#&K:JFD±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
ÃÜ¶È Õ³¶È ζÈ
.457 3.55 500
.525 3.25 400 poejµÀhK:JFD()±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
.616 2.93 300
.675 2.75 250 kjhfjouierpK:JFD()$#_*±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
.746 2.57 200 f8e342ÊÇK:JFD()$±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
.835 2.38 150 #*($(Ŷ*&#%K:JFD()$#_*±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
.946 2.17 100 cvmmvckjlureK:JFD()$#_*(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
1.09 1.95 50 dsaf12zcv54K:JFD()$#_*±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
1.29 1.71 0 5a4f8e342K:JFD()$#±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
¹«Ê½ ˵Ã÷£¨½á¹û£© 1fd3s1fK:JFD()±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
=VLOOKUP(1,A2:C10,2) ÔÚ A ÁÐÖвéÕÒ 1£¬²¢´ÓÏàͬÐÐµÄ B ÁÐÖзµ»ØÖµ (2.17) (&#*($(Ŷ*K:JFD()$#_±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
=VLOOKUP(1,A2:C10,3,TRUE) ÔÚ A ÁÐÖвéÕÒ 1£¬²¢´ÓÏàͬÐÐµÄ C ÁÐÖзµ»ØÖµ (100)
=VLOOKUP(.7,A2:C10,3,FALSE) ÔÚ A ÁÐÖвéÕÒ 0.746¡£ÒòΪ A ÁÐÖÐûÓо«È·µØÆ¥Å䣬ËùÒÔ·µ»ØÁËÒ»¸ö´íÎóÖµ (#N/A) s13¶«oitre43K:JFD()$#_*(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
=VLOOKUP(0.1,A2:C10,2,TRUE) ÔÚ A ÁÐÖвéÕÒ 0.1¡£ÒòΪ 0.1 СÓÚ A ÁеÄ×îСֵ£¬ËùÒÔ·µ»ØÁËÒ»¸ö´íÎóÖµ (#N/A) )#$@&%#*(ÎK:JFD()$#_±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
=VLOOKUP(2,A2:C10,2,TRUE) ÔÚ A ÁÐÖвéÕÒ 2£¬²¢´ÓÏàͬÐÐµÄ B ÁÐÖзµ»ØÖµ (1.71) K:JFD()$#_±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
kjhfjouieK:JFD()$#±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
¾ßÌå¿Éµ½excel°ïÖúÀÊäÈëvlookup,ºÜÏêϸ 434321%$K:JFD()$±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
¶*&#%kcvmK:JFD()$#±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ

»Ø´ðÕߣº ÏèÓÎÀË×Ó     »Ø´ðʱ¼ä£º2009-05-19 15:02    

12        14        


¿´Ò»ÏÂexcelµÄ°ïÖú¾Í¿É½â¾öÒÓ~~
sÒ²f12dK:JFD()±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ

»Ø´ðÕߣº lamchunhuii     »Ø´ðʱ¼ä£º2009-05-19 15:12    

12        13        


´ð£º·¢¸öÊÓƵÁ´½Ó¸øÄã¿´¿´£¬Ï£ÍûÓÐÓÃ
fjouiK:JFD±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
VlookupÓ÷¨Àh$#$#&)K:JFD()$±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ

ÊÓƵ: º¯Èë°àµÚ5½²:Ìõ¼þ²éѯVLOOKUP cvmmvckjlurK:JFD()$#_*±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ

[flash]http://player.youku.com/player.php/sid/XNjUzODA1NTY=/v.swf[/flash]%#*(ÎÒ)$#@K:JFD()$#_±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
4321%$#(*K:JFD()$#±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ

»Ø´ðÕߣº wangyuan072     »Ø´ðʱ¼ä£º2009-05-19 16:17    

13        15        


ÀÁµÄ1B£¬±ÉÊÓÄãdsÒ²f1K:JFD(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ

»Ø´ðÕߣº horizon668     »Ø´ðʱ¼ä£º2009-05-24 13:05    

12        14        


ºÇºÇ VLOOKUP ²Ù×÷ÖÐ ×îÖ÷ÒªµÄÒ»µã¾ÍÊǼÇס ÔÚµÚ3ÐÐÌîдʱ Êý¶ÔÄã´Ó²éÕÒÁе½Ä¿±êÁÐÊǵڼ¸ÁУ¬±ÈÈç5 ¾ÍÌî5  Õâ¸öÊÇȷȷʵʵµÄÊýÖµ ²»ÒªÌîΪÆäËûµÄ¾ÍOKÁË

»Ø´ðÕߣº wweinano     »Ø´ðʱ¼ä£º2009-05-31 15:32    

11        8        

ÖйúͨÐÅÈ˲ÅÍø | ½­ËÕͨÐÅÈ˲ÅÍø | ɽ¶«Í¨ÐÅÈ˲ÅÍø | Î人ͨÐÅÈ˲ÅÍø | Õ㽭ͨÐÅÈ˲ÅÍø | ºþÄÏͨÐÅÈ˲ÅÍø
³É¶¼ÆìѶͨÐż¼ÊõÓÐÏÞ¹«Ë¾ Ƹ£º³É¶¼ÕÐ5G²âÊÔ¡¢¸ß¼¶IMC¹¤³Ìʦ
ÐèÇóÈËÊý£º12 ÈË µØµã£º³É¶¼ÊÐ,ÑÅ°²ÊÐ,ãòÖÝÊÐ,üɽÊÐ,ÄϳäÊÐ
ÖØÇìÐÅ¿ÆͨÐŹ¤³ÌÓÐÏÞ¹«Ë¾ Ƹ£ºIMCÕÐƸ-°ÍÖÐ
ÐèÇóÈËÊý£º1 ÈË µØµã£º°ÍÖÐÊÐ
º¼Öݶ«ÐÅÍøÂç¼¼ÊõÓÐÏÞ¹«Ë¾ Ƹ£ºLTE/5GÍøÂçÖи߼¶ÓÅ»¯¹¤³Ìʦ
ÐèÇóÈËÊý£º2 ÈË µØµã£ºÉϺ£ÊÐ
ÉϺ£ÈðºÌͨѶ¼¼ÊõÓÐÏÞ¹«Ë¾ Ƹ£º¹ãÖÝÖи߼¶¹¤³Ìʦ
ÐèÇóÈËÊý£º3 ÈË µØµã£º¹ãÖÝÊÐ
¼Î»·¿Æ¼¼¹É·ÝÓÐÏÞ¹«Ë¾ Ƹ£º²âÊÔ¹¤³Ìʦ
ÐèÇóÈËÊý£º15 ÈË µØµã£ºÀ¥Ã÷ÊÐ,ÁÙ²×ÊÐ,µÂºêÖÝ,ºìºÓÖÝ,ÓñϪÊÐ
¹ãÖݳþ³¿ÍøÂç¿Æ¼¼ÓÐÏÞ¹«Ë¾ Ƹ£º4G/5Gºǫ́Öи߼¶¹¤³Ìʦ
ÐèÇóÈËÊý£º12 ÈË µØµã£º¹ã¶«Ê¡
±±¾©µçÆìͨѶ¼¼Êõ¹É·ÝÓÐÏÞ¹«Ë¾ Ƹ£ºÍøÓÅʵϰÉúͨÐÅÓ¦½ìÉú£¨ÔÆÄÏ£©
ÐèÇóÈËÊý£º1 ÈË µØµã£ºÀ¥Ã÷ÊÐ,˼éÊÐ,ÕÑͨÊÐ
¸£ÖݺëÓîÐźÏͨÐż¼ÊõÓÐÏÞ¹«Ë¾ Ƹ£º×¨¼Ò¸Úλ
ÐèÇóÈËÊý£º8 ÈË µØµã£ºÀ¥Ã÷ÊÐ
Õã½­Ã÷ѶÍøÂç¼¼ÊõÓÐÏÞ¹«Ë¾ Ƹ£º¸ß¼¶ÍøÓŹ¤³Ìʦ£¨IMC)-н®
ÐèÇóÈËÊý£º4 ÈË µØµã£ºÎÚ³ľÆëÊÐ
°²»ÕÒý;¿Æ¼¼ÓÐÏÞ¹«Ë¾ Ƹ£º¹¤³ÌÓÅ»¯ÏîÄ¿¾­Àí
ÐèÇóÈËÊý£º1 ÈË µØµã£ººØÖݵØÇø
ÈȵãÎÊÌâ
¸ü¶à¾«²Ê

ÁªÏµÎÒÃÇ - ÎÊͨÐÅר¼Ò Powered by MSCBSC Òƶ¯Í¨ÐÅÍø  © 2006 -