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

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

°}¦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

        ÀR«ä¦Û¦b : ¤p¨Æ¤£°µ¡B¤j¨ÆÃø¦¨¡C
ªð¦^¦Cªí ¤W¤@¥DÃD