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

[µo°Ý] ½Ð°Ý±_ª¬¨ç¼ÆIF+INDEX+MATCH¼g§¹«á¥X²{#VALUE!®É¸Ó«ç»ò¿ì?

[µo°Ý] ½Ð°Ý±_ª¬¨ç¼ÆIF+INDEX+MATCH¼g§¹«á¥X²{#VALUE!®É¸Ó«ç»ò¿ì?

¥»©«³Ì«á¥Ñ 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´£¤U­n«ç»ò°µ¤~¯à¨Ï³o­Ó¨ç¼Æª½±µ¦³µª®×©O?

·P¿E¤£ºÉ¡I

§ä¤£¨ìµª®×ªº®z¤k¤l¯d

¦^´_ 1# sax868

=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)))
   ¦]¬°§Aªº¬d¸ßªí®æ¤w¸g¤£¬O³æÄ檺Àx¦s®æ°Ñ·Ó
'Updated Data'!A:A&'Updated Data'!D: D&'Updated Data'!M:M
³o¼Ë·|±NA¡BD¡BM³o3Äæ ¦ê³s¦¨¤@­Ó°}¦C
µM«á¦b¦¹°}¦C¤¤´M§ä·j´M­È$C$1&$A12&$J12
©Ò¥H¥²¶·¬O°}¦C¤½¦¡¤~¯à¥¿½T°õ¦æ
¤£¹L³o¼Ë¾ãÄ檺°Ñ·Ó¦pªG¦A2003ª©¥»¬O¦æ¤£³qªº¡A2003ª©ªº°}¦C¤½¦¡¤£®e³\¾ãÄæ©Î¾ã¦Cªº°Ñ·Ó
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# Hsieh

³á~­ì¨Ó¦p¦¹¡IÁÂÁ¶W¯Åª©¥Dªº²M·¡¸ÑÄÀ¡I·P®¦~~~

TOP

        ÀR«ä¦Û¦b : ¤H­n¦Û·R¡A¤~¯à·R´¶¤Ñ¤Uªº¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD