¦]¬°Àɮ׸ê®Æ¯A¤Î¤½¥q¦¨¥»»P°â»ù¡A¤£¤è«K´£¨Ñ¡A¶È¥Î´yz¡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) |