Dim cel As Range, c As Range
With Feuil1
For Each cel In .Range("G2:G" & .Range("G65000").End(xlUp).Row)
If cel <> "" Then
Set c = Feuil2.Range("A2:C7").Find(cel)
If Not c Is Nothing Then
cel.Offset(, 3) = Feuil2.Cells(1, c.Column)
Else
cel.Offset(, 3) = "vendeur inconnu"
End If
End If
Next
End With