Sub QuelEquipe()
Application.ScreenUpdating = False
Dim Ws As Worksheet, Rg As Range, i&, Zone
Set Ws = Worksheets("Feuille 1")
Zone = "E2:L11"
For i = 2 To Range("A" & Rows.Count).End(xlUp).Row
Set Rg = Ws.Range(Zone).Find(What:=Ws.Range("A" & i), lookat:=xlWhole)
If Not Rg Is Nothing Then
Ws.Range("B" & i) = Ws.Cells(1, Rg.Column)
Else
Ws.Range("b" & i) = "Pas trouvé"
End If
Next i
End Sub