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

[µo°Ý] (¤w¸Ñ¨M)vlookup »P¤é´Á®æ¦¡

[µo°Ý] (¤w¸Ñ¨M)vlookup »P¤é´Á®æ¦¡

¥»©«³Ì«á¥Ñ freeffly ©ó 2012-2-22 17:23 ½s¿è

¦pªþ¥[Àɬ°¤°»ò¶À¦â°Ï¶ôªº³¡¤À§ìªº¨ì­È
¦ý¬O¥t¤@­ÓÃC¦â«o§ì¤£¨ì?
¬O§Ú¤½¦¡¦³°ÝÃDÁÙ¬O¤é´ÁÅã²{ªº¤è¦¡¤]·|¼vÅT¶Ü?

°ÝÃD.rar (2.91 KB)

¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

B26°}¦C¤½¦¡
{=MAX(IF($D$28:$H$50=A26,$E$28:$I$50))}
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¤½¦¡ªºÅÞ¿è¬O²V¶Ãªº¡C¦b$D$28:$E$50ùØ­±§ä¤£¨ì¡§ISERROR(VLOOKUP(A47,$D$28:$E$50,2,0))¡¨¡A¨º麽¨ì$F$28:$G$50ùØ­±¥h§ä¡§VLOOKUP(A47,$F$28:$G$50,2,0)¡¨¡F­Y¦b$D$28:$E$50ùØ­±§ä¨ì¤F¡A§Aªð¦^ªº¬O¡GIF(ISERROR(VLOOKUP(A47,$F$28:$G$50,2,0)),VLOOKUP(A47,$H$28:$I$50,2,0),"")¡A¦b$F$28:$G$50ùØ­±¨S§ä¨ìA47¡A¥¦ªð¦^¡§¡¨¡A©Ò¥H¾ã­Ó¤½¦¡ªð¦^¡§¡¨¡C
«ö§Aªº«ä¸ô¡G
=IF(ISERROR(VLOOKUP(A47,$D$28:$E$50,2,0)),IF(ISERROR(VLOOKUP(A47,$F$28:$G$50,2,0)),IF(ISERROR(VLOOKUP(A47,$H$28:$I$50,2,0)),"",VLOOKUP(A47,$H$28:$I$50,2,0)),VLOOKUP(A47,$F$28:$G$50,2,0)),VLOOKUP(A47,$D$28:$E$50,2,0))
³o¼Ëªº¤½¦¡¤£­n»¡¼g¡A¬Ý³£¬Ý·w¤F¡C

TOP

¦^´_ 2# Hsieh


  ³o­Ó¤½¦¡¥i¥H¥Î ¦ý¬O§Ú¤£ª¾¹D¬°¤°»ò¥i¥H³o¼Ë¥Î
max ¸ò if ¦b¥[¤W°}¦C¥i¥H¥Î³oºØ¤è¦¡¨Ó·j´M¸ê®Æ¶Ü?
max§Ú¤ñ¸ûÃø²z¸Ñ¥i¥H¸Ñ»¡¤@¤U¶Ü
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

¦^´_ 3# et5323


    §Ú­ì¥»ªºÅÞ¿è¬O¦pªG²Ä¤@°Ï¶ô¬O¿ù»~´N´M§ä²Ä¤G°Ï¶ô
   ¦pªG²Ä¤G°Ï¶ô¿ù»~´N´M§ä²Ä¤T°Ï¶ô
   ¦pªG²Ä¤T°Ï¶ô¿ù»~´N´M§ä²Ä¤@°Ï¶ô
   §_«h´NªÅ¥Õ
   ¤£ª¾¹D³oºØÅÞ¿è¤W¦³¨S¦³°ÝÃD
   ¦]¬°§Ú±`¥Î³oºØ¤è¦¡§ä¸ê®Æ
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

¥»©«³Ì«á¥Ñ ¦Ñ®L ©ó 2010-9-23 18:36 ½s¿è

ÀÝ¥ÎVLOOKUP()
¬P´Á¤é«D¥æ©ö¤é,·íµM¶Ç¿ù»~­È
*************************
½d³ò¤ºÄæ¦ì¦WºÙ¦³2­Ó,ªÅ¥ÕÀx¦s®æ

¨­¤ÀÃÒ¦r¸¹¥i¥H­«½Æ¶Ü?


½Ð¥ý¬Ý¨ç¼Æ»¡©úÀÉ
¦b¦A°Ý°ÝÃD

TOP

¦^´_ 4# freeffly
½Ð«ä¦Ò¦Ñ®L«e½úªº¦^ÂÐ
­n¨Ï¥ÎVLOOKUP¸ê®Æªí®æ­n¦X¥G¸ê®Æªíªº­n¨D³o¬O³Ì°ò¥»ªº
°w¹ï§Aªºªí®æÀ¿§¾ªÑ¡A¤~·|¥ÎMAX+IF
¦]¬°§Aªºªí®æ¤é´Á¦³³æ¤@©Ê(¤£­«½Æ)
©Ò¥H¡A¥ÎIF¨ú±o¤é´Á®Çªº¼Æ­È¡A¥u¦³²Å¦X¤é´Á¤~·|¦³­È§_«h¶Ç¦^0ªº°}¦C
©Ò¥H³o°}¦C¤¤ªº³Ì¤j­È´N¬O²Å¦X¤é´Áªº¨º­Ó­È
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 6# ¦Ñ®L


¬P´Á¤é¬O§Ú³]©w¿ù»~
¥i¬Ovlookup¨ç¼Æ»¡©ú¨S¦³»¡¤£¯à©ñ­«½Æ©ÎªÅ¥Õªº¸ê®Æ
¤§«e§Ú¥Î¦pªG­«½Æ¸ê®Æ¥LÀ³¸Ó³£¬O§ì²Ä¤@µ§
¤j¤j»¡ªº³¡¤À¬O¨ç¼Æ»¡©ú¸Ì­±¦³ªº³¡¤À¶Ü?
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

¦^´_ 7# Hsieh


    ÁÂÁÂÁ¿¸Ñ
   vlookup ¥u¯à¥Î¦b¤£­«½Æ¦Ó¥B³sÄòªº¸ê®Æ¶Ü
   ¦]¬°¨ç¼Æ»¡©ú¨S¦³Á¿¨ì³o­Ó­­¨î
   ¤§«e¥Î¨Ó§ì¸ê®Æ¤]¨S¦³°ÝÃD
   ³o¬O²Ä¤@¦¸¬Ý¨ì¦U¦ì¤j¤j»¡³o­Ó°ÝÃD
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

¨ç¼Æ¤£¬O°ÝÃD¡A°ÝÃD¬O§A§â¸ê®Æ¤À¦¨¤T­Ó°Ï¶ô¨Ó¼W¥[¤½¦¡ªº§xÃø«×¤Îªø«×¡A³o¼Ë­È±o¶Ü¡H

TOP

        ÀR«ä¦Û¦b : ¥Ç¿ù¥XÄb®¬¤ß¡A¤~¯à²M²bµL·Ð´o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD