- ©«¤l
- 2833
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 2889
- ÂI¦W
- 0
- §@·~¨t²Î
- ¡e²¤¡f
- ³nÅ骩¥»
- ¡e²¤¡f
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¡e²¤¡f
- µù¥U®É¶¡
- 2013-5-13
- ³Ì«áµn¿ý
- 2024-11-12
|
°}¦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,),""))
=========================== |
|