本帖最後由 sillykin 於 2020-12-30 00:13 編輯
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
想請問要如何用VBA表示 |
發表於 2020-12-30 00:02
| 
