Sub Matching()
Dim ColA As Range
Dim ColB As Range
Dim Cell As Range
Dim c As Range
Dim ValD As String
Dim ValA As String
Set ColA = Sheets(1).Range('A1:A' & Range('A65536').End(xlUp).Row)
Set ColB = Sheets(1).Range('d1:d' & Range('d65536').End(xlUp).Row)
On Error Resume Next
For Each c In ColB
c.Offset(0, 1) = 1
c.Offset(0, 2) = 0
valeur = c.Row
ValD = c
ValD = Trim(ValD)
ValD = Mid(ValD, 1, InStr(ValD, ' ') - 1)
ValD = UCase(ValD)
For Each Cell In ColA
ValA = Cell
ValA = Trim(ValA)
ValA = Mid(ValA, InStr(ValA, ' ') + 1, Len(ValA))
ValA = UCase(ValA)
If CStr(ValA) = CStr(ValD) Then
c.Offset(0, 1) = Cell.Offset(0, 1)
c.Offset(0, 2) = Cell.Offset(0, 2)
End If
Next Cell
Next c
End Sub