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

[µo°Ý] ¦p¦ó°w¹ïvlookup¥Î¨â±ø¥ó°µ°Ñ·Ó?

¦^´_ 10# at58441215

1.¬Û¹ï¦ì§},µ´¹ï¦ì§}¤§¨Ï¥Î­nª`·N
  ³Ì«á$G$2:$G$22­n¥Îµ´¹ï¦ì§}
2.¤@­ÓÃD¥Ø¥»¨Ó´N·|¦³«Ü¦h¸Ñªk,¼ô½mªº¤èªk³Ì¦n¥Î

TOP

¦^´_ 11# register313


    ¤F¸Ñ~·PÁ´£¿ô    §Ú±`±`¤£¬O§Ñ¤F¥[¬A©·´N¬O§Ñ¤F¥[¨M¹ï­È ;P

TOP

½Ð°Ý¦U¦ì¦³µL¤èªk­ø¥X 0 ¦Ó«Y¥X 6370031024 ©O¤@²Õ¼Æ.

TOP

¦^´_ 13# ONT


   
¥¼©R¦W.PNG
2012-3-27 10:13
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

ÁÂÁÂHsieh¤j¤jÀ°¦£¤X¡C
¦ý¤µ¤Ñ¤S¹J¨ì¤@­Óvlookup°ÝÃD,·í¤Þ¼Æ«e¦h¥ª ' ³o­Ó
²Å¸¹®É§Y '1234 «K¤£¯à°÷¶i vlookup¡A½Ð°Ý¦³¨ä¥L¨ç
¼Æ±N³o­Ó²Å¸¹²¾°£¦Ó¤S¯à°÷±N1234«O«ù¼Æ¦r®æ¦¡¡C

TOP

¦^´_ 15# ONT

¦h¤F³æ¤Þ¸¹ªº¼Æ¦r´N¦¨¤F¤å¦r
VLOOKUP¥²¶·®æ¦¡¤]¬O¬Û¦P¤~¯à¤ñ¹ïªº¨ì
¤£ª¾¹D§A¬O­n§ï¦¨¤å¦rÁÙ¬O¼Æ¦r¨Ó¤ñ¹ï
­Y­n¥h°£³æ¤Þ¸¹¨Ï¥Î´M§ä¨ú¥N¥\¯à¥i¯àµLªk¹F¨ì
¥i§Q¥Î¸ê®Æ­åªR¥\¯à¨Ó±N¸ê®Æ«¬ºA­«·s©w¸q
play.gif
2012-3-28 22:28
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 9# register313


    ½Ð°Ýr¤j ¸Ó«ç»ò§JªA  sumproduct ±a¥X¨Ó¼Æ¦r·|¦Û°Ê§â0¥h±¼    ¨Ò:  01234Åܦ¨1234
Jason

TOP

¦^´_ 3# renzhi2020


½Ð°Ý¤@¤U¤j¤j=IF(ISERROR(LOOKUP(2,1/(($E$2:$E$22=A2)*($F$2:$F$22=B2)))),0,LOOKUP(2,1/(($E$2:$E$22=A2)*($F$2:$F$22=B2)),($G$2:$G$22)))  ¤½¦¡ LOOKUP(2,1/    ³o¬O¤°»ò·N«ä°Ú??   ¤×¨ä¬O2,1/  ¯uªº¤£À´= =  Àµ½Ð¤j¤jÀ°¦£¸Ñ»¡
Jason

TOP

Really helpful!! Appreciated

TOP

§Ú¨Ó¸Õ¸Õ¬Ý¡A¬Ý¶]¥X¨Óµ²ªG¦p¦ó!ÁÂÁÂ!

TOP

        ÀR«ä¦Û¦b : ¡i¥Í©R¦b©I§l¶¡¡j¦òªû»¡¡G¡u¥Í©R¦b©I§l¶¡¡C¡v¤HµLªkºÞ¦í¦Û¤vªº¥Í©R¡A§óµLªk¾×¦í¦º´Á¡AÅý¦Û¤v¥Ã¦í¤H¶¡¡C¬JµM¥Í©R¥h¨Ó³o»òµL±`¡A§Ú­Ì§óÀ³¸Ó¦n¦n¦a·R±¤¥¦¡B§Q¥Î¥¦¡B¥R¹ê¥¦¡AÅý³oµL±`¡BÄ_¶Qªº¥Í©R¡A´²µo¥¦¯uµ½¬üªº¥ú½÷¡A¬M·Ó¥X¥Í©R¯u¥¿ªº»ù­È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD