Vlookup problem using vba

[Alpacino]

I have a 2 columns in columns AB for names and AC for figures these go down to rows 34. I have another list in column A with the same list of names in a different order I want to use a vlookup formula to match the figures from AC To the names in column A and put the figures in column B

I have tried this:
Dim i As Double
For i = 2 to 34
Cells(I, 2).Value = Application.WorksheetFunction.Vlookup(cells(i, 1).Value,Range("AB2:AC34"),2,0)

Next i

But it has error on worksheet function
Anyone help
Thanks
Alan

 

[ziad alsayed]

it should be .formulaR1C1 and not .value, it is better you name the range

try the below, try the below it is for variable range

For i = 2 To finalrow
        On Error Resume Next
            Cells(i, 2).FormulaR1C1 = Application.WorksheetFunction.VLookup(Cells(i, 1), Range("lookuptable"), 3, False)
            On Error GoTo 0
        Next i

 

[Alpacino]

Thank you for that