XL 2013 Recherche V avec deux criteres - mix colonne et ligne

=SIERREUR(RECHERCHEV(A1;'ORDER FORM'!A:J;EQUIV(B1;'ORDER FORM'!$1:$1;0);0);"")

=SOMMEPROD(('ORDER FORM'!$A$2:$A$20=$A1)*('ORDER FORM'!$C$1:$J$1=$B1)*'ORDER FORM'!$C$2:$J$20)

Option Explicit
Private Sub Worksheet_Activate()
Dim Col&, Lig&, LCible&, CCible As Range
Set CCible = Feuil2.Columns("A:C")
    LCible = 1
    CCible.ClearContents
    For Lig = 2 To WorksheetFunction.CountA(Feuil1.Columns(1))
        For Col = 3 To WorksheetFunction.CountA(Feuil1.Rows(1))
            Feuil2.Cells(LCible, 1) = Feuil1.Cells(Lig, 1)
            Feuil2.Cells(LCible, 2) = Feuil1.Cells(1, Col)
            Feuil2.Cells(LCible, 3) = Feuil1.Cells(Lig, Col)
            LCible = LCible + 1
        Next Col
    Next Lig
    CCible.Columns.AutoFit
End Sub