I am essentially trying to use VBA to perform a Vlookup command, that increments the row, for example B2, B3, B4 and such.

I have created the code below, to increment the row in the Vlookup, however it keeps debugging. Has anyone run into this issue? Thanks.


lastsymbol = Cells(Rows.Count, "H").End(xlUp).Row
  For I = 2 To lastsymbol

      With Sheets("Data")
.Cells(I, 8) = "=VLOOKUP(B" & I & ",'C:\Master Lookupxls]Project -> Year Lookup'!$A$1:$B$65536,2,0)"""
      End With
      
   Next I