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

[µo°Ý] ¬d§ä³Ì¤j­È

[µo°Ý] ¬d§ä³Ì¤j­È

¦]¬°Àɮ׸ê®Æ¯A¤Î¤½¥q¦¨¥»»P°â»ù¡A¤£¤è«K´£¨Ñ¡A¶È¥Î´y­z¡C
¦s³fsheet¡G¤½¥qªº¦s³f©ú²Ó¡ABÄæ¬O®Æ¸¹¡AEÄæ¬O¦s³f³æ¦ì¦¨¥»
¤@¦~¤º¾P³f©ú²Ósheet¡G¤½¥q¤@¦~¤ºªº¾P°â¸ê®Æ¡A²Ä10Äæ¬O³æ¦ì°â»ù
»Ý¨D¬O¡G¦pªG¦b¤@¦~¤º¦³¾P°â¬ö¿ý¡A´N§ì¨ú¸Ó®Æ¸¹ªº³æ¦ì°â»ù¡A¦pªG¨S¦³´N§ì³æ¦ì¦¨¥»¡A¦ý§Ú¤Uªº¤½¦¡VLOOKUP(¦s³f!$B:$B,¤@¦~¤º¾P³f©ú²Ó!Y:AH,10,)¥u·|§ì¨ú²Ä¤@µ§¸ê®Æ¡A½Ð°Ý­n¦p¦ó§ó¥¿¡H
¦b¤@¦~¤º¾P³f©ú²Ósheet·|¦³°h³f©Î§éÅýªº°ÝÃD¡A©Ò¥H³æ¦ì°â»ù¦³¥i¯à¥X²{"0"©Î"#DIV/0!"ªº­È¡A¬O§_»Ý­n¥ý±Æ°£¡H

IF(COUNT(0/(VLOOKUP(¦s³f!B:B,¤@¦~¤º¾P³f©ú²Ó!Y:AH,10,)>1)),VLOOKUP(¦s³f!$B:$B,¤@¦~¤º¾P³f©ú²Ó!Y:AH,10,),E7)

¦^´_ 3# ML089


    ½Ð°ÝML089ª©¥D
¥ÎVBA¼gªº¸Ü­n¦p¦óVlookup§PÂ_³Ì¤j­È©O?
¤@¤À§V¤O¡A¤@¤À¦¬Ã¬¡C
µo°ÝÃD«e¥i¥H¥ý·j¯Á¤º¤å¬O§_¦³¬ÛÃö½d¨Ò¡C

TOP

ÁÂÁÂ#ML089ªº¦^ÂÐ

¸g´ú¸Õ¦³¹F¨ì¤u§@¤Wªº»Ý¨D¡A¤£¹L¦³¤@°ÝÃD»Ý§JªA¡A´N¬O¦b¤@¦~¤º¾P³f©ú²Ósheet·|¦³°h³f©Î§éÅýªº°ÝÃD¡A©Ò¥H³æ¦ì°â»ù¦³¥i¯à¥X²{"0"©Î"#DIV/0!"ªº­È¡A¦Ó³y¦¨¤½¦¡µ²ªG¥X²{#DIV/0!

½Ð°Ý³o¸Ó¦p¦ó§JªA¡AÁÂÁ¡C

TOP

¦^´_ 1# shootingstar

­Y¦³¦hµ§­n¨ú³Ì¤j­È

=MAX( IF(¬d¸ß­È=¤@¦~¤º¾P³f©ú²Ó!Y1:Y9999, ¤@¦~¤º¾P³f©ú²Ó!AH1:AH9999, E7) )
°}¦C¿é¤J (¥ý¦P®É«ö CTRL¡BSHIFT¤£©ñ¡A¦A«ö ENTER)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¥»©«³Ì«á¥Ñ ML089 ©ó 2018-7-17 17:39 ½s¿è

¥i¥H¥Îiferror¨ç¼Æ¤ñ¸û²³æ

=IFERROR(VLOOKUP(¬d¸ß­È, ¤@¦~¤º¾P³f©ú²Ó!Y:AH,10,), E7)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : §ïÅܦۤv¬O¦Û±Ï¡A¼vÅT§O¤H¬O±Ï¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD