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

[µo°Ý] INDIRECT¦p¦ó¥Î¦Û©w¸q

[µo°Ý] INDIRECT¦p¦ó¥Î¦Û©w¸q

½Ð°Ý¥ô¦ó¹ï¨ç¼Æ¦³¬ã¨s¤Î¿³½ìªº°ª¤â­Ì
BX4=IF($BY4=0,"",CHOOSE(MATCH(711,INDIRECT("'"&DAY($F$1)-1&"'!DP4:DS4"),0),INDIRECT("'"&DAY($F$1)-1&"'!CY4"),INDIRECT("'"&DAY($F$1)-1&"'!DB4"),INDIRECT("'"&DAY($F$1)-1&"'!DE4"),INDIRECT("'"&DAY($F$1)-1&"'!DH4")))

BX4¤½¦¡¬O­n±a¥X«e¤@¤é²Å¦XA1®Æ¸¹ªºDP4:DS4Äæ¦ì,¥u­n¥X²{"711"¥N½X,´N§â«e¤@¤éCYÄ檺¤é´Á±a¨ìBX4Äæ¦ì
¦]¬°¤½¦¡«Üªø,§Ú·Q¥Î¦Û©w¸q¤è¦¡,¦ý¦³¨Ç°ÝÃDµLªk§JªA
1. ¤u§@ªíªº©R¦W¬O1:31ªº¤é´Á
©Ò¥H§Ú·|§Q¥Î INDIRECT("'"&DAY($F$1)-1Åý¨C­Ó¤u§@ªí³£¥i¥H§Q¥Î¦P¤@¬¡°Ê¤½¦¡
¦ý,INDIRECTªº¯S©Ê,¬O­n§â¨ú¥Xªº­È¥]¦b""¤¤,³o¼Ë¥Î¦Û©w¸q·|¥X²{¿ù»~­È
2. ·Q½Ð±Ð¦³¨S¦³¨ä¥L¤½¦¡¥i¥H´À´«¥Ø«eªº¤½¦¡?¦ý­n¦³¦P¼Ëªº¥\¯à
3. ©ÎªÌ­ì¤½¦¡¥i¥H§ï¦¨¤@­P©Êªº¡A¨Ò¦p¡GMATCH(711,INDIRECT("'"&DAY($F$1)-1&"'!DP4:DS4"),0)¦³¨ä¥Lªº¼gªk,¥i¥H±NDP4:DS4§ï¦¨DP4:DS7(¥Ø«eªºÁ`¦C¼Æ)
®w¦sªí_INDIRECT.rar (28.9 KB)

°}¦C¤½¦¡(¤TÁ䧹¦¨):
=IF($BY4=0,"",iferror(HLOOKUP(711,VLOOKUP(D4,INDIRECT("'"&DAY($F$1)-1&"'!D:DS"),99+{18,19,20,21;1,1,1,1},),2,),""))

©Î ¤@¯ë¤½¦¡:
=IF($BY4=0,"",IF(OR(VLOOKUP(D4,INDIRECT("'"&DAY($F$1)-1&"'!D:DS"),116+{1,2,3,4},)=711),VLOOKUP(D4,INDIRECT("'"&DAY($F$1)-1&"'!D:CY"),100,),""))


===========================

TOP

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

­ã¤j ¦n¡G

³o¤GºØ¼gªk§Ú´ú¸Õ«áµo²{,¥u¦³·í"711"¥X²{¦bDP4:DS4 ªº²Ä¤@­ÓÀx¦s®æDP4®É,¤~·|±a¥X¥¿½T¸ê®Æ,¤£µM´N·|¥X¿ù,¥i¯à­n¦A¬ã¨s¤@¤U¡I

TOP

        ÀR«ä¦Û¦b : ¨Ã«D¦³¿ú¾{¬O§Ö¼Ö¡A°Ý¤ßµL·\¤ß³Ì¦w¡C
ªð¦^¦Cªí ¤W¤@¥DÃD