Find a vector inside a matrix

[hcova]

Hi there.
Is there any way to find if a vector of numbers is contained in a matrix. (I would like to use an excel formula for this purpose) .
Let me explain it better with the below table.
In this example I would like to know if the vector {11, 14, 22, 24, 37, 39, 31} stored in cells D1:J1 is contained in the matrix D5:J35.
As you can see, the matrix contains the vector in line 28

In tried the formula =IF(ISNUMBER(MATCH(D1:J1, D5:J35, 0)), "Found", "Not Found") but it doesn't work.
Any help is welcome
Hernan

 

[Peter_SSs]

What about

=IF(ISNUMBER(MATCH(TEXTJOIN("|",,D1:J1),D5:D37&"|"&E5:E37&"|"&F5:F37&"|"&G5:G37&"|"&H5:H37&"|"&I5:I37&"|"&J5:J37,0)),"Found","Not Found")

 

[snjpverma]

Untested alternatives,
Try this,

=IFERROR(IF(SUM(IFERROR(MATCH(D1:J1,D5:J35,0),0))=7,"Yes","No"),"No")

Or this,

=IF(COUNTIF($D$5:$J$35,D1)+COUNTIF($D$5:$J$35,E1)+COUNTIF($D$5:$J$35,F1)+COUNTIF($D$5:$J$35,G1)+COUNTIF($D$5:$J$35,H1)+COUNTIF($D$5:$J$35,I1)+COUNTIF($D$5:$J$35,J1)=7,"Yes","No")

 

[hcova]

What about

=IF(ISNUMBER(MATCH(TEXTJOIN("|",,D1:J1),D5:D37&"|"&E5:E37&"|"&F5:F37&"|"&G5:G37&"|"&H5:H37&"|"&I5:I37&"|"&J5:J37,0)),"Found","Not Found")

Thanks a lot

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.