vba - vba vlookup/错误处理-类型不匹配错误

Question

我正在获取run time error 13 - type mismatch error
有任何想法吗？

outputCell = "=IF(ISNA(VLOOKUP(A" & row & ",'Current Defects'!$A$" & 2 & ":$B$" & 1000 & ",2,FALSE))," - ", (=VLOOKUP(A" & row & ",'Current Defects'!$A$" & 2 & ":$B$" & 1000 & ",2,FALSE))"

Answer 1

在第二个(=之前摆脱VLOOKUP。

您也没有在IsNA函数中正确转义双引号。

在一行上，尝试:

outputCell = "=IF(ISNA(VLOOKUP(A" & row & ",'Current Defects'!$A$" & 2 & ":$B$" & 1000 & ",2,FALSE)),"" - "", VLOOKUP(A" & row & ",'Current Defects'!$A$" & 2 & ":$B$" & 1000 & ",2,FALSE))"

为了清晰起见，请将其分成多行:

outputCell = "=IF(ISNA(VLOOKUP(A" _
                  & row & ",'Current Defects'!$A$" & 2 & ":$B$" & 1000 & ",2,FALSE))," _
                  & """ - "", VLOOKUP(A" & row & ",'Current Defects'!$A$" & 2 & ":$B$" _
                  & 1000 & ",2,FALSE))"