Salut Horusbk, ça faisait un bout de temps, dis donc...
Salut les as,
mais, si, bien sûr, en VBA...
Private Sub Worksheet_Change(ByVal Target As Range)
'
Application.EnableEvents = False
'
If Not Intersect(Target, [C2]) Is Nothing Then _
[C3].Resize(1, 3) = "": _
If [C2] <> "" Then _
Set rCel = Worksheets("Archives").Columns(1).Find(what:=Target, lookat:=xlWhole, LookIn:=xlValues): _
[C3].Resize(1, 3) = Array(Replace(rCel.Offset(0, 2).Address, "$", ""), CDate(rCel.Offset(0, 1)), IIf(rCel.Offset(0, 2) = "", "?", rCel.Offset(0, 2)))
'
Application.EnableEvents = True
'
End Sub
A+