Sub essai()
Dim xrg As Range
Set xrg = Nothing
Set xrg = Sheets("Feuil1").Range("b:b").Find("inventaire", _
after:=Sheets("Feuil1").Range("B1"), searchdirection:=xlPrevious, _
LookIn:=xlValues, lookat:=xlPart, MatchCase:=False)
If Not xrg Is Nothing Then Sheets("Feuil2").[b5] = xrg.Value Else Sheets("Feuil2").[b5] = CVErr(xlErrNA)
End Sub