Rebonjour a tous, du coup j'ai fais ca , ca marche merci a tous 👍👍👍
Sub Macro9()
[J15].FormulaR1C1 = _
"=TRIM(INDEX(LEFT(Recup!R[-14]C[-9]:R[24]C[-9],16),SUMPRODUCT((ISNUMBER(SEARCH(R[-8]C[-7],Recup!R[-14]C[-9]:R[-5]C[-9])))*ROW(Recup!R[-14]C[-9]:R[-5]C[-9]))))"
[J15] =...