vlookup only returns zero when looking at sum

[Godders199]

Hello, I have the following vlookup vba, which is looking at the result of a sum formula =SUM(AQ2+AR2+AS2)

Dim u As Long

With Sheets("submissions")
u = .Cells(.Rows.Count, 1).End(xlUp).Row
End With

With ActiveSheet
LR5 = .Cells(.Rows.Count, 13).End(xlUp).Row - 1
With .Cells(2, 29).Resize(LR5)
.Formula = "=VLOOKUP(m2,'submission'!$s$1:$at$" & u & ",28,0)"
.Value = .Value
.Replace "#N/A", ""
End With
End With

but it will only return Zero,however if i type the vlookup formula in, it will return the correct value.


Is there a reason why the vba only returns zero, I use this vba all the time and normally works fine?

 

[wideboydixon]

Have you got the right spelling of the sheet name? First instance is "submissions" but second one only says "submission".

WBD

 

[Godders199]

thanks, did not see that for looking... always the most obvious thing