Salut dann,
voici une solution en VBA.
iRow = Range("B:B").Find(what:=Me.ComboBox1.Text, lookat:=xlWhole, searchdirection:=xlNext).Row
iRow = Range("B" & iRow & ":B" & Rows.Count).Find(what:="volume empreinte", lookat:=xlWhole, searchdirection:=xlNext).Row
'
Range("AB11").Value = Cells(iRow, 2).Offset(0, Val(Me.ComboBox2.Text)).Value
A+