Bonjour
Une solution avec le fonction FIND :
Sub cherche()
Dim i
On Error Resume Next
For i = 2 To Cells(Rows.Count, "C").End(xlUp).Row
Set adresse = [B:B].Find(What:=Cells(i, "C"), LookAt:=xlPart)
If Not (adresse Is Nothing) Then Cells(i, "D") = "OK"
Next
End Sub
fred