Tu peux tester cette fonction
Function h(cel)
cherche = UCase(cel.Parent.Name) & cel.Value & "Arrivée"
With Sheets("horaires")
Set r = .Columns(5).Find(cel.Parent.Name)
If r Is Nothing Then Exit Function
ad = r.Address
Do
Set v = Sheets("horaires").Columns(5).FindNext(r)
If UCase(r) & r.Offset(0, -3) & r.Offset(0, 1) = cherche Then
h = r.Offset(0, -2).Value
Exit Function
End If
Loop While Not r Is Nothing And r.Address <> ad
End With
End Function