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

[µo°Ý] Âù±ø¥ó§PÂ_

[µo°Ý] Âù±ø¥ó§PÂ_

½Ð°Ý¦U¦ì¥ý¶i

¦pªþ¥ó¡A¤w±N³W«h¼g¦bÀɮפº¡ASÄæ­n¦p¦ó¤U¤½¦¡¤~¯à¥¿½T§PÂ_ÁöµM¤@¦~¤º¦³¥X¹L³f¦ý¦]¬°°â»ù<=1¡Aµ²ªGÀ³¸Ó¬O°â»ù(2)¡C

¦ÓH~MÄæÁÙ¥i¥H¦p¦ó¤U¤½¦¡¡C

¥H¤W¡AÁÂÁ¡C

´ú¸Õ.rar (22.3 KB)

¢â¢³¡G
=IF(COUNTIF(±ø¥ó!A:A,A4),VLOOKUP(A4,±ø¥ó!A:C,2,),IF(COUNT(0/(VLOOKUP(A4,'201509~201608'!A:D,4,)>1)),"°â»ù(1)","°â»ù(2)"))
©Î
=LOOKUP("ùÜ",CHOOSE({1,2,3},"°â»ù(2)",IF(VLOOKUP(A4,'201509~201608'!A:D,4,)>1,"°â»ù(1)"),VLOOKUP(A4,±ø¥ó!A:C,2,)))


¢Ö¢³¡G=IF($F4="0-365",$D4,0)¡@¡@¥k©Ô¤U©Ô

TOP

¦^´_ 2# ­ã´£³¡ªL

ÁÂÁ ­ã´£³¡ªL ª©¥Dªº¦^ÂÐ

¤£¹L²Ä¤G­Ó¤½¦¡=LOOKUP("ùÜ",CHOOSE({1,2,3},"°â»ù(2)",IF(VLOOKUP(A4,'201509~201608'!A:D,4,)>1,"°â»ù(1)"),VLOOKUP(A4,±ø¥ó!A:C,2,)))
¤£¤Ó¯à²z¸Ñ¡A¥i§_°µ­Ó»¡©ú¡AÁÂÁ¡C

TOP

¦^´_ 3# shootingstar


³o¤£¦n¸ÑÄÀ,
»Ý¨Dª¬ªp¦³¤T­Ó, ²Ä2¤Î²Ä3­Ó­Y¤£²Å¦X®É, ±N¥X²{¿ù»~­È, §_«hÅã¥Ü¹ïÀ³[¤å¦r],
lookup("ùÜ", ¤å¦r1,¤å¦r2©Î#n/a,¤å¦r3©Î#n/a) , ·|¨ú¥X³Ì«á¤@­Ó[¤å¦r], ¦Ó©¿²¤¿ù»~­È#n/a

=CHOOSE({1,2,3},"°â»ù(2)",IF(VLOOKUP(A4,'201509~201608'!A:D,4,)>1,"°â»ù(1)"),VLOOKUP(A4,±ø¥ó!A:C,2,))
¦b¤½¦¡½s¿è®æ«ö¢Ô¢¸¡A¥i¥H¬Ý¦UºØª¬ªp¡I

TOP

        ÀR«ä¦Û¦b : «Î¼e¤£¦p¤ß¼e¡C
ªð¦^¦Cªí ¤W¤@¥DÃD