¥»©«³Ì«á¥Ñ sax868 ©ó 2012-5-8 17:49 ½s¿è
#VALUE!.zip (285.68 KB)
¦U¦ì¤j¤j¤È¦w¡I
½Ð°Ý·í§Ú¼g¤F±_ª¬¨ç¼Æ =IF($A12="","",INDEX('Updated Data'!AX:AX,MATCH($C$1&$A12&$J12,'Updated Data'!A:A&'Updated Data'!D: D&'Updated Data'!M:M,0))) «áª½±µ«öEnter¥X²{#VALUE!¡A
¦ý¬O¦pªG¦bÁÙ¨S¼g¦n¨ç¼Æ©ó¡¨0¡¨¤§«áª½±µ«öCtrl+Shift+Enter,¦A«öYes§Y¦³µª®× ( =IF($A12="","",INDEX('Updated Data'!AX:AX,MATCH($C$1&$A12&$J12,'Updated Data'!A:A&'Updated Data'!D: D&'Updated Data'!M:M,0)
½Ð°Ý¦pªG¦b¤£«öCtrl+Shift+Enterªº«e´£¤Un«ç»ò°µ¤~¯à¨Ï³oÓ¨ç¼Æª½±µ¦³µª®×©O?
·P¿E¤£ºÉ¡I
§ä¤£¨ìµª®×ªº®z¤k¤l¯d |