¥»©«³Ì«á¥Ñ sillykin ©ó 2020-12-30 00:13 ½s¿è
C6~c200
C6=IF(D6="","",$C$4)
C7=IF(D7="","",$C$4)
C8=IF(D8="","",$C$4)
¦ÜC200
---------------------------------------------------
F6~F200
F6¤½¦¡=IF(ISNA(VLOOKUP($A6,»¡©ú!$B:$E,3,FALSE)),"",(VLOOKUP($A6,»¡©ú!$B:$E,3,FALSE)))
F7¤½¦¡=IF(ISNA(VLOOKUP($A7,»¡©ú!$B:$E,3,FALSE)),"",(VLOOKUP($A7,»¡©ú!$B:$E,3,FALSE)))
F8¤½¦¡=IF(ISNA(VLOOKUP($A8,»¡©ú!$B:$E,3,FALSE)),"",(VLOOKUP($A8,»¡©ú!$B:$E,3,FALSE)))
¦ÜF200
G6~G200
G6=IF(ISNA(VLOOKUP($A6,»¡©ú!$B:$E,4,FALSE)),"",(VLOOKUP($A6,»¡©ú!$B:$E,4,FALSE)))
G7=IF(ISNA(VLOOKUP($A7,»¡©ú!$B:$E,4,FALSE)),"",(VLOOKUP($A7,»¡©ú!$B:$E,4,FALSE)))
¦ÜG200
·Q½Ð°Ýn¦p¦ó¥ÎVBAªí¥Ü |