各位大大好,我想問下vlookup出現下圖 #n/a 是正常嗎?附上vba碼。謝謝 LR = Range("a1").End(xlDown).Row LLR = Range("b1").End(xlDown).Row For I = 4 To 40 Step 1 Cells(I, 2) = "=VLOOKUP(a" & I & ",I:N,2,0)" Cells(I, 3) = "=VLOOKUP(a" & I & ",I:N,4,0)" Cells(I, 4) = "=VLOOKUP(a" & I & ",I:N,6,0)*100" Next I
正常,A欄沒東西可以比對就會顯示NA,如果要美觀就加個條件上去:Cells(I, 2) = "if(isna(VLOOKUP(a" & I & ",I:N,2,0)),"",VLOOKUP(a" & I & ",I:N,2,0))"2、3、4一樣比照↑