Private Sub Worksheet_Change(ByVal Target As Range)
Dim T As Range
If Target.CountLarge > 1 Then Exit Sub
If Target.Address = "$F$2" And Target(1, 1) <> "" Then
Set T = Columns("$A:$A").Find(Target, LookAt:=xlWhole)
If T Is Nothing Then
MsgBox "Code non trouvé"
Else
T.Offset(0, 1) = Target.Value
End If
End If
End Sub