re,
à tester,
Sub test()
Range("B2:B6").Formula = "=INDEX(Feuil1!B:B,MATCH(A2,Feuil1!A:A,0))"
Range("B2:B6") = Range("B2:B6").Value
End Sub
un autre possibilité,
Sub test2()
Dim sh1 As Worksheet, sh2 As Worksheet, rw As Long, i As Long
Set sh1 = Sheets("Feuil1")
Set sh2 = Sheets("Feuil2")
rw = sh2.Cells(Rows.Count, 1).End(xlUp).Row
For i = 2 To rw
sh2.Cells(i, 2) = Application.Index(sh1.Range("B:B"), Application.Match(sh2.Cells(i, 1), sh1.Range("A:A"), 0))
Next i
End Sub