Hi

I use VLookp in lines of the programmig however, the code is get same error
Option Explici
4 5 8
d0 n1 d0 n
d1 n2 d1 n
d3 n3 d3 n
d4 n4 d4 n
d5 n5 d20 erro
d6 n6
d7 n7

Sub Macro1(
Dim i As Intege
Dim a, b As Strin

Dim rangea, rangeb As rang

Set rangea = range(Cells(2, 4), Cells(20, 5)
Set rangeb = range(Cells(2, 8), Cells(20, 8)


For i = 0 To 3
a = Cells(2 + i, 8
Cells(2 + i, 9) = iif(IsError(Application.WorksheetFunction.VLookup( a, rangea, 2, False)), 1,_ Application.WorksheetFunction.VLookup(a, rangea, 2, False)
Next
End Su


Run-time error '1004'

VLookup method of Range class faile

Can someone help me with this