vlookup错误处理，错误2042(vlookup error handling, error 2042)

 我试图让Vlookup在VBA中工作，我有这个代码： 
 
Dim Result As Variant

    For i = 2 To lastrow
        Result = Application.VLookup(Template.Range("A" & i).Value2, EDM.Range("B:BP"), 5, False)
        If IsError(Result) Then
            Template.Range("E" & i).Value2 = ""
        Else
            Template.Range("E" & i).Value2 = Result
        End If
    Next i
 
 出于某种原因，每个细胞都是空白的。 如果我在匹配的单元格中手动键入公式，它可以正常工作。 我猜这可能与错误处理有关，也许？ 目标是在模板，A列中针对EDM列B查找值并返回EDM列G. 

I'm trying to get a Vlookup working in VBA, and I have this code:
 
Dim Result As Variant

    For i = 2 To lastrow
        Result = Application.VLookup(Template.Range("A" & i).Value2, EDM.Range("B:BP"), 5, False)
        If IsError(Result) Then
            Template.Range("E" & i).Value2 = ""
        Else
            Template.Range("E" & i).Value2 = Result
        End If
    Next i
 
For some reason every cell is coming up blank. If I manually type the formula in a cell with a match it works fine. I'm guessing it has something to do with the error handling, maybe? The goal is to look up the value in Template, column A against EDM column B and return EDM Column G.

原文：https://stackoverflow.com/questions/41449608