Option Explicit
Sub Merci_job75()
Dim d As Object, t, i&, P As Range
Set d = CreateObject("Scripting.Dictionary")
t = Feuil2.[A1].CurrentRegion.Resize(, 2)
For i = 1 To UBound(t)
d(t(i, 1)) = t(i, 2)
Next
Set P = Feuil1.[a:b]
t = P
For i = 2 To UBound(t)
If d.exists(t(i, 1)) Then t(i, 2) = d(t(i, 1)) Else t(i, 2) = ""
Next
P.Columns(2) = Application.Index(t, , 2)
' Columns("b:b").NumberFormat = "m/d/yyyy": [b1] = "date anniv." ' ligne inutile...
End Sub