Check Row is in range

[Cooki]

Is there a way to check if the row is in the range, but does not need to be in the same order, just as long as its in the row.

I have one that checks if the data if the is an exact match, but needs to all be in the same order =MAX(MMULT(--EXACT(A2:D2,$A$2:$D$5),{1;1;1;1}))=4

Example

Row to check

Hat

Cat

Dog

Fish

Range

Hat	Can	Dog	Fish
Bat	Dog	Fat	Tan
Fish	Dog	Cat	Hat
Bat	Can	Fat	Tan

As you can see there is a match in row 3

Thought changing the exact for match might work, but did not =MAX(MMULT(MATCH(C2:F2,$I$2:$L$5),{1;1;1;1}))=4

TIA

 

[StephenCrump]

See Post #15 here: Check Row Matches a row in an array

 

[Fluff]

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).