bonjour, modifier cette macro en ceci
Private Sub Worksheet_Change(ByVal Target As Range)
Dim C As Range, cT2 As Range
Set C = Intersect(Target, Range("Tableau1[Parcelle]"))
If C Is Nothing Then Exit Sub
If C.Value = "" Then Exit Sub
Set cT2 = Sheets("feuil2").Range("Tableau2") 'le tableau dans une autre feuille
r = Application.Match(C.Value, cT2.Columns(1), 0)
If IsNumeric(r) Then C.Offset(, 2).Value = cT2(r, 2).Value Else MsgBox "faux parcelle", vbExclamation
End Sub